Logical functions provide basic comparison and return TRUE or FALSE values based on the evaluation of the formula.
NOTE: The arguments in virtually all functions can be either an actual value or a reference to a cell with a value. For example, ABS (C4) returns the absolute value of the number in cell C4. Cell C4 can be a formula as well thus building an interrelationship between many cells in the table. However, be careful to avoid circular references (formulas that refer to cells that ultimately refer to the original cell).
|
Returns TRUE if all the evaluated expressions are TRUE. Returns false if any expressions are false. Empty cells are ignored.
| |
|
Evaluates an expression and returns a defined value or text based the on the results.
| |
|
Returns TRUE if all the referenced cells are empty.
| |
|
Evaluates cells for date values. If dates are found, TRUE is returned. Cells with numbers or text return FALSE. Formatting cells with a date format does not transform cells with numbers into dates.
| |
|
If the expression reference contains errors except for #N/ A!, the function returns TRUE.
| |
|
If the expression reference contains any errors, the function returns TRUE.
| |
|
If the expression reference contains any logical values, the function returns TRUE.
| |
|
If the expression reference contains any #NA! (not available) errors, the function returns TRUE.
| |
|
If the expression reference contains any number values, the function returns TRUE.
| |
|
If the expression reference contains any text values, the function returns TRUE.
| |
|
Returns the logical opposite of the expression. TRUE values are returned as FALSE and vice-versa. For numeric values, zero is treated as FALSE, all other values are treated as TRUE.
| |
|
Returns TRUE if any of the evaluated expressions are TRUE. Returns FALSE if all expressions are false. Empty cells are ignored. |