ISLOGICAL

The ISLOGICAL function in Excel is used to check if a value is a logical value (TRUE or FALSE). It returns TRUE if the value is a logical value and FALSE if it is not.

Syntax

=ISLOGICAL(value)

value The value you want to check if it is logical (TRUE or FALSE).

About ISLOGICAL

When you need to verify whether a specific value in Excel represents a logical TRUE or FALSE, the ISLOGICAL function comes in handy. Its primary purpose is to examine a given input and determine if it qualifies as a logical value according to Excel's conventions. By employing ISLOGICAL, you can swiftly ascertain if a cell contains a logical TRUE/FALSE content, facilitating data validation and manipulations in spreadsheets effortlessly.

Examples

If you have a cell with the value TRUE, you can check if it is a logical value using the ISLOGICAL function. For instance, if the value is in cell A1, the formula would be: =ISLOGICAL(A1)

Similarly, you can verify if a cell contains a logical value like FALSE by applying the ISLOGICAL function. For instance, if the value is in cell B5, the formula would be: =ISLOGICAL(B5)

Questions

What does the ISLOGICAL function return if the value provided is TRUE?

The ISLOGICAL function will return TRUE if the value provided to it is the logical value TRUE.

What does the ISLOGICAL function return if the value provided is not TRUE or FALSE?

If the value provided to the ISLOGICAL function is not TRUE or FALSE, it will return FALSE.

Can the ISLOGICAL function be used with text values?

No, the ISLOGICAL function is designed to specifically check for logical TRUE or FALSE values. It will not return TRUE for text values, even if they resemble 'TRUE' or 'FALSE'.

Related functions

ISNUMBER
ISTEXT
ISBLANK
ISERROR
ISNA
ISNONTEXT