by John MacDougall | May 7, 2016 | Information
This function will test if a value is numerical and return TRUE if it is a number and FALSE if it’s not. Syntax ISNUMBER(Value) Value (required) – This is the value you want to test if it’s a number. Example In this... by John MacDougall | May 5, 2016 | Information
This function will test if a value is text and return TRUE if it is text and FALSE if it’s not. Syntax ISTEXT(Value) Value (required) – This is the value you want to test if it’s text. Example In this example we test a few... by John MacDougall | May 3, 2016 | Logical
This function will return TRUE if exactly one of the arguments are TRUE and FALSE otherwise. Syntax XOR(Expression1, Expression2, Expression3, … ) Expression1 (required) – This is an expression that can evaluate to either TRUE or FALSE.... by John MacDougall | May 3, 2016 | Logical
This function will return TRUE if one or more of the arguments are TRUE and FALSE if all the are FALSE. Syntax OR(Expression1, Expression2, Expression3, … ) Expression1 (required) – This is an expression that can evaluate to either TRUE or... by John MacDougall | May 3, 2016 | Logical
This function will return TRUE if all arguments are TRUE and FALSE otherwise. Syntax AND(Expression1, Expression2, Expression3, … ) Expression1 (required) – This is an expression that can evaluate to either TRUE or FALSE. Expression2,...