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

 

 

Copyright © 2000-2016 StatsDirect Limited, all rights reserved. Download a free trial here.