Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ISLOGICAL Function

Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.


ISLOGICAL(<value>)

Term

Definition

value

The value that you want to test.

TRUE if the value is a logical value; FALSE if any value other than TRUE OR FALSE.

The following three samples show the behavior of ISLOGICAL.

//RETURNS: Is Boolean type or Logical
=IF(ISLOGICAL(true), "Is Boolean type or Logical", "Is different type")

//RETURNS: Is Boolean type or Logical
=IF(ISLOGICAL(false), "Is Boolean type or Logical", "Is different type")

//RETURNS: Is different type
=IF(ISLOGICAL(25), "Is Boolean type or Logical", "Is different type")

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.