Excel Functions

Excel ISLOGICAL Function

Pinterest LinkedIn Tumblr

The Excel ISLOGICAL function is used to check for a logical value (ie: TRUE or FALSE). This function returns TRUE if the value is a logical value such as TRUE or FALSE.

Purpose of Excel ISLOGICAL Function

Test if a value is logical.

Return value

This function returns a logical value (TRUE or FALSE).


=ISLOGICAL (value)


valueThe value to test as logicalMandatory

Usage notes

  • This function is part of a group of functions called the IS functions, which are often used to test the result of formulas for errors.
  • Normally, value is supplied as a cell address.


Since 2007 for Windows.

Since 2011 for Mac.

Related Posts

Write A Comment