ISLOGICAL

ISLOGICAL(value)

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

valueThe 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.
* For the Microsoft documentation refer to support.microsoft.com

 AB
1=ISLOGICAL(TRUE) = TrueFalse
2=ISLOGICAL(FALSE) = TrueTrue
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 

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top