Workbook Functions: Logical
AND(logical list)
True if all arguments are true, false if at least one is false.
e.g. AND(A1+B1>5, A1+C1<10) true if A1=4, B1=2 and C1=5, false if C1=6.
ERROR.TYPE(reference)
Number corresponding to an error occurring in the specified reference cell.
See also: ISERR, ISERROR
EXACT(expresion1, expression2)
True if the two text expressions are identical (case-sensitive); False if not.
See also: LEN, SEARCH
FALSE( )
Logical value False.
See also: TRUE
IF(condition, true_value, false_value)
Tests the condition and returns the true_value if condition is TRUE or false_value if condition is FALSE.
See also: AND, FALSE, NOT, OR, TRUE
ISBLANK(reference)
Returns TRUE if the specified reference cell is blank and FALSE otherwise.
See also: ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT
ISERR(expression)
Returns TRUE if the specified expression returns an error and FALSE otherwise.
See also: ISBLANK, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT
ISLOGICAL(expression)
Returns TRUE if the expression returns a logical value and FALSE otherwise.
See also: ISBLANK, ISERR, ISERROR, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT
ISNA(expression)
Returns TRUE if the expression returns the #N/A! error and FALSE otherwise.
See also: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISREF, ISTEXT
ISNONTEXT(expression)
Returns TRUE if there is a non-text value in the expression and FALSE otherwise.
See also: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNUMBER, ISREF, ISTEXT
ISNUMBER(expression)
Returns TRUE if the expression returns a number and FALSE otherwise.
See also: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISREF, ISTEXT
ISREF(expression)
Returns TRUE if the expression returns a range reference and FALSE otherwise.
See also: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISTEXT
ISTEXT(expression)
Returns TRUE if the expression text and FALSE otherwise.
See also: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF
N(value)
Tests the supplied value and returns the value if it is a number or 1 if the value is the logical function TRUE(). All other values are returned as 0.
See also: T, VALUE
NA()
Returns the error value #N/A (not available)
See also: ISNA
NOT(logical)
Returns TRUE if logical is FALSE and vice-versa.
See also: AND, IF, OR
OR(logical list)
TRUE if at least one of a series of logical arguments in the list is true.
See also: AND, IF, NOT
T(value)
Returns the value if it is a text.
See also: CELL, N, VALUE
TRUE()
Logical value TRUE.
See also: FALSE
TYPE(expression)
Argument type of the given expression: 1 for numbers, 2 for text strings, 4 for logical values and 16 for error values.
See also: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT