Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Information > ISLOGICAL

 

ISLOGICAL(value)

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

 valueThe value you want to test.

 REMARKS
 
  • The "value" can refer to a value, text string, cell reference, formula or a named range.

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

     Functions - I | Index - I | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top