Logical spreadsheet functions
|
•
|
|
@AND Returns 1 (true) if all arguments are true, 0 (false) if even one argument is false.
|
|
•
|
|
@FALSE Always returns the logical value 0.
|
|
•
|
|
@FILEEXISTS Checks to see whether the named file exists. Returns a logical true (1) or false (0) value.
|
|
•
|
|
@IF Evaluates a specified condition, and returns the specified expression if it is true, or another specified expression if it is false.
|
|
•
|
|
@ISBLANK Tests a specified cell to see if it is empty.
|
|
•
|
|
@ISBLOCK Tests input to see if it is a defined cell name or valid cell coordinates.
|
|
•
|
|
@ISERR Returns 1 if a specified cell contains ERR (error indicator), otherwise 0.
|
|
•
|
|
@ISEVEN Returns 1 (true) if a specified number is even, 0 (false) if it is odd.
|
|
•
|
|
@ISLOGICAL Returns 1 (true) if its argument refers to a 1 or 0; it returns 0 (false) if its argument refers to any other number.
|
|
•
|
|
@ISNA Returns 1 if a specified cell is NA (not available), otherwise 0.
|
|
•
|
|
@ISNONTEXT Returns 1 (true) if its argument refers to any item that is not text. @ISNONTEXT also returns 1 if Value refers to an empty cell.
|
|
•
|
|
@ISNUMBER Returns 1 if a specified cell contains a number, otherwise 0.
|
|
•
|
|
@ISODD Returns 1 (true) if a specified number is odd, 0 (false) if it is even.
|
|
•
|
|
@ISSTRING Returns 1 if a specified cell contains a label or text string, otherwise 0.
|
|
•
|
|
@NOT Reverses the value of its argument; for example if the expression is FALSE, @NOT returns TRUE; if the expression is TRUE, @NOT returns FALSE.
|
|
•
|
|
@OR Returns 1 (true) if any argument is true, 0 (false) only if all arguments are false.
|
|
•
|
|
@TRUE Always returns the logical value 1.
|