Excel > Function References > Information Functions

ISLOGICAL function

Returns the result TRUE if value refers to a logical value; otherwise, it returns FALSE.

Syntax

ISLOGICAL(value)

Argument	Description	Remarks
value	The value that you want tested. Value can be a blank (empty) cell, error, logical expression, text, number, reference value, or a name referring to any of these, that you want to test.	Value arguments enclosed with quotation marks are treated as text. They are never converted.

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

A	B
Formula	Description (Result)
=ISLOGICAL(TRUE)	Checks whether TRUE is a logical value (TRUE)
=ISLOGICAL("TRUE")	Checks whether "TRUE" is a logical value (FALSE)

See also
ERROR.TYPE function
ISBLANK function
ISERR function
ISERROR function
ISNA function
ISNUMBER function
TYPE function
List of all functions (by category)

Share your feedback about this topic

Rate this content: