<< Click to Display Table of Contents >> ISLOGICAL (is a logical value?)

Syntax:

ISLOGICAL(Cell)

Description:

This returns TRUE if the given cell contains a logical value (i.e., TRUE or FALSE).

Example:

If A1 contains TRUE and C7 contains a text string, the following applies:

ISLOGICAL(A1) returns TRUE

ISLOGICAL(C7) returns FALSE

See also:

ISTEXT, ISNUMBER, ISREF, ISNONTEXT