ISLOGICAL (is a logical value?)

<< Click to Display Table of Contents >>

ISLOGICAL (is a logical value?)

Syntax:

ISLOGICAL(Reference)

Description:

Returns TRUE if the specified cell contains a logical value (i.e., TRUE or FALSE).

Example:

If A1 contains TRUE, and C7 contains a text string, then:

ISLOGICAL(A1) returns TRUE

ISLOGICAL(C7) returns FALSE

See also:

ISTEXT, ISNUMBER, ISREF, ISNONTEXT