The Excel ISLOGICAL function is an Information formula that returns TRUE if the input is a logical value, and a FALSE result otherwise. As the name suggests, the formula asks the question "Is logical?" to the argument value. This formula can be especially useful in error handling, troubleshooting, and checking whether a cell contains any logical checks. In this guide, we’re going to show you how to use the Excel ISLOGICAL function and also go over some tips and error handling methods.


Supported versions

  • All Excel versions

Excel ISERROR Function Syntax

ISLOGICAL(value)


Arguments

value The value you want to test.

Example

The ISLOGICAL function, like the other IS… functions, requires a single argument as the input. The argument can be any cells, logical values, strings, numbers, reference values, or a named range referring to any of these. A common use case for this function is testing the outcome of a cell containing formulas. This way, you can quickly analyze the outcome type of a data range. The function returns TRUE if the cell contains logical values like TRUE or FALSE.

=ISLOGICAL(FALSE) returns TRUE

=ISLOGICAL(4=4) returns TRUE

=ISLOGICAL("text") returns FALSE

Download Workbook


Tips

  • Even though Excel considers them Boolean values, ISLOGICAL function does not count 1 (ones) and 0 (zeros) as logical values.
  • You can use the ISLOGICAL function as logical test inside an IF function.
    =IF(ISLOGICAL(A1),"Logical","Not logical")
  • IFERROR function can be used to return a specific value if there is an error in the argument cell.
  • Below is a list of other IS… functions.
    • ISBLANK to test blank cells
    • ISERR to test error values except #N/A
    • ISERROR to test all error values
    • ISNA to test #N/A error value specifically
    • ISNUMBER to test numbers
    • ISTEXT to test texts
    • ISNONTEXT to test any item that is not a text
    • ISREF to test a reference