ISLOGICAL

ISLOGICAL(value)

Returns the boolean True or False depending if the value is True or False.

value

The value you want to test.

REMARKS

* A value that is either True or False is called a logical value.
* The "value" can refer to a value, text string, cell reference, formula or a named range.
* You can use the ISBLANK function to return the boolean True or False depending if the value is blank.
* You can use the ISEVEN function to return True or False depending if the value is an even number.
* You can use the ISODD function to return True or False depending if the value is an odd number.
* You can use the ISTEXT function to return True or False depending if the value is text.
* You can use the ISINTEGER - User Defined Function function to return if a number is an integer.
* You can use the ISPRIME - User Defined Function function to return if a number is a prime number.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=ISLOGICAL(TRUE) = True	False
2	=ISLOGICAL(FALSE) = True	True
3	=ISLOGICAL(B1) = True
4	=ISLOGICAL(B1) = True
5	=ISLOGICAL("TRUE") = False
6	=ISLOGICAL(1) = False
7	=ISLOGICAL(0) = False
8	=ISLOGICAL("some text") = False
9	=ISLOGICAL(named_range) = True