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

NOT(logical)

 
 Returns the boolean value which is the negation of its argument.

 logicalThe value or expression that can be evaluated to True or False.

 REMARKS
 
  		• You should use this function when you want to make sure a value is not equal to one particular value.
     
  		• If "logical" evaluates to False, then TRUE is returned.
     
  		• If "logical" evaluates to True, then FALSE is returned.

     EXAMPLES
     
     A
    1=NOT(FALSE) = True
    2=NOT(TRUE) = False
    3=NOT(1+1=2) = False
    4=NOT(5<10) = False
    5=NOT(5=10) = True
    6=NOT(5>10) = True
    7=IF(NOT(FALSE),"True","False") = True
    		 
     Functions - N | Index - N | Office Online 

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