|
![]() |
|
![]() |
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). |
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 )
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.
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 )
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 )
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)
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)
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)
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)
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)
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)
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 )
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 |