ISLOGICAL Function in Google Sheets

Determine if a value is a logical value (TRUE or FALSE) using the ISLOGICAL function.

ISLOGICAL Function

The ISLOGICAL function in Google Sheets is used to check if a value is a logical value (TRUE or FALSE).

Syntax

ISLOGICAL(value)
  • value: The value or expression you want to test. This is a required parameter.

Example

  1. Logical Value Check

Check if a value is a logical value:

=ISLOGICAL(TRUE)

This will return TRUE.

Notes

  • Returns TRUE only if the value is either TRUE or FALSE.
  • Useful for testing logical conditions in formulas.
  • ISNUMBER: Check if a value is numeric.
  • ISTEXT: Check if a value is text.