Gobe Productive User's Guide - Logical Functions

- Working in the spreadsheet environment
- Formatting cells
- Row & column sizes
- Number formats
- Insert, Delete, Move & Go to Cells
- Locking cells
- Filling cells
- Sorting cells
- Calculating cells & Dependent cells
- Formulas & functions
- Function reference
- Creating a chart
- Working with charts
- Styles
- Named selections
- Display options
- Spell checking
- Writing tools
- Views & layers
- Working with spreadsheet frames

# Logical Functions

AND | ISDATE | ISLOGICAL | ISTEXT
IF | ISERR | ISNA | NOT
ISBLANK | ISERROR | ISNUMBER | OR

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