Logical Functions

Logical functions provide basic comparison and

Reminder:  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).

AND

Returns TRUE if all the evaluated expressions are TRUE. Returns false if any expressions are false.  Empty cells are ignored.

Syntax

AND( expression, {expression}, ... )

Arguments

expression Values or references to examine.

Example

AND( TRUE, FALSE ) returns FALSE
AND( A2..B5 )

IF

Evaluates an expression and returns a defined value or text based the on the results.

Syntax

IF( qualifier, true-response, {false-response} )

Arguments

qualifier The analysis expression to use. This can contain other functions and references. 
true-response Value or reference to return if the qualifier is TRUE.   If omitted, nothing is displayed.
false-response Value or reference to return if the qualifier is FALSE.   If omitted, nothing is displayed.

Example

IF( (SUM(A2..A5)) < 1000, "Running Low", "OK")

This function displays the text "Running Low" if the sum of A2 through A5 is less than 1000, otherwise "OK" is displayed.

ISBLANK

Returns TRUE  if all the referenced cells are empty.

Syntax

ISBLANK( expression, {expression}, ... )

Arguments

expression Values or references to examine.

Example

ISBLANK( A2..B5, D2..E5 )

ISDATE

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.

Syntax

ISBLANK( expression, {expression}, ... )

Arguments

expression Values or references to examine.

Example

ISDATE( A2 )

ISERR

If the expression reference contains errors except for #N/A!, the function returns TRUE.

Syntax

ISERR( expression )

Arguments

expression Values or references to examine.

Example

ISERR( 3/0 ) returns TRUE
iSERR (A1..C9)

ISERROR

If the expression reference contains any errors, the function returns TRUE.

Syntax

ISERROR( expression )

Arguments

expression Values or references to examine.

Example

ISERROR( 3/0 ) returns TRUE
ISERROR (A1..C9)

ISLOGICAL

If the expression reference contains any logical values, the function returns TRUE.

Syntax

ISLOGICAL( expression )

Arguments

expression Values or references to examine.

Example

ISLOGICAL( FALSE ) returns TRUE
ISLOGICAL (A1..C9)

ISNA

If the expression reference contains any #NA! (not available) errors, the function returns TRUE.

Syntax

ISNA( expression )

Arguments

expression Values or references to examine.

Example

ISNA (A1..C9)

ISNUMBER

If the expression reference contains any number values, the function returns TRUE.

Syntax

ISNUMBER( expression )

Arguments

expression Values or references to examine.

Example

ISNUMBER ("Gobe") returns FALSE
ISNUMBER (A1..C9)

ISTEXT

If the expression reference contains any text values, the function returns TRUE.

Syntax

ISTEXT( expression )

Arguments

expression Values or references to examine.

Example

ISTEXT( 2+5 ) returns FALSE
ISTEXT (A1..C9)

NOT

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.

Syntax

NOT( expression )

Arguments

expression Values or references to examine.

Example

NOT( TRUE ) returns FALSE
NOT( A2 )

OR

Returns TRUE if any of the evaluated expressions are TRUE. Returns FALSE if all expressions are false.  Empty cells are ignored.

Syntax

OR( expression, {expression}, ... )

Arguments

expression Values or references to examine.

Example

OR( TRUE, FALSE ) returns TRUE
OR( A2..B5 )


Copyright © 1999, Gobe Software, Inc