ISLOGICAL function

Category: Information
Introduced: Excel 2003

Summary

Returns TRUE if the value is a logical value

Syntax

ISBLANK(value) ISERR(value)
ISERROR(value)
ISEVEN(value)
ISLOGICAL(value)
ISNA(value)
ISNONTEXT(value)
ISNUMBER(value)
ISODD(value)
ISREF(value)
ISTEXT(value)
The IS function syntax has the following argument:
• value Required. The value that you want tested. The value argument can be a blank (empty cell), error, logical value, text, number, or reference value, or a name referring to any of these.
ISBLANK | Value refers to an empty cell.
ISERR | Value refers to any error value except #N/A.
ISERROR | Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
ISEVEN | Value refers to an even number.
ISLOGICAL | Value refers to a logical value.
ISNA | Value refers to the #N/A (value not available) error value.
ISNONTEXT | Value refers to any item that is not text. (Note that this function returns TRUE if the value refers to a blank cell.)
ISNUMBER | Value refers to a number.
ISODD | Value refers to an odd number.
ISREF | Value refers to a reference.
ISTEXT | Value refers to text.

Example

=ISLOGICAL(TRUE)
=ISLOGICAL("TRUE")
=ISNUMBER(4)
=ISREF(G8)
=ISREF(XYZ1)
=ISBLANK(A2)
=ISERROR(A4)
=ISNA(A4)
=ISNA(A6)
=ISERR(A6)
=ISNUMBER(A5)
=ISTEXT(A3)

Microsoft Support Page

#NOT_FOUND

Back to Functions