ISLOGICAL Function in Excel – Test whether the cell has logical values

ISLOGICAL Function in Excel tests if a supplied value or expression returns a logical value(i.e. TRUE or FALSE). If so the ISLOGICAL Function returns TRUE, if not the function returns FALSE.

Syntax of ISLOGICAL Function in Excel:

ISLOGICAL(value)

Where value argument is the value or argument to be tested.

 

Example of ISLOGICAL Function in Excel:

Formula

ISLOGICAL Function in Excel 1

  • The above example takes up simple values, Expressions and cell reference as input and returns TRUE only if the resultant value is logical, otherwise the function returns FALSE

Result:

ISLOGICAL Function in Excel 2

previous-small ISLOGICAL Function in Excel                                                                                                                next_small ISLOGICAL Function in Excel