# 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.

EXACT(expresion1, expression2)

True if the two text expressions are identical (case-sensitive); False if not.

FALSE( )

Logical value False.

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.

ISBLANK(reference)

Returns TRUE if the specified reference cell is blank and FALSE otherwise.

ISERR(expression)

Returns TRUE if the specified expression returns an error and FALSE otherwise.

ISLOGICAL(expression)

Returns TRUE if the expression returns a logical value and FALSE otherwise.

ISNA(expression)

Returns TRUE if the expression returns the #N/A! error and FALSE otherwise.

ISNONTEXT(expression)

Returns TRUE if there is a non-text value in the expression and FALSE otherwise.

ISNUMBER(expression)

Returns TRUE if the expression returns a number and FALSE otherwise.

ISREF(expression)

Returns TRUE if the expression returns a range reference and FALSE otherwise.

ISTEXT(expression)

Returns TRUE if the expression text and FALSE otherwise.

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.

NA()

Returns the error value #N/A (not available)

NOT(logical)

Returns TRUE if logical is FALSE and vice-versa.

OR(logical list)

TRUE if at least one of a series of logical arguments in the list is true.

T(value)

Returns the value if it is a text.

TRUE()

Logical value TRUE.

TYPE(expression)

Argument type of the given expression: 1 for numbers, 2 for text strings, 4 for logical values and 16 for error values.