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

AND(logical1, logical2 [,logical3] [, …])

 
 Returns the logical AND for any number of arguments.

 logical1The first logical value.
 logical2The second logical value.
 logical3The third optional logical value.

 REMARKS
 
  		• The logical values can be constants, logical equations, cell references or named ranges.
     
  		• If any argument does not evaluate to either True or False, then #VALUE! is returned.
     
  		• This function can be used to check if values meet certain criteria.
     
  		• You can have a maximum of 30 arguments.

     EXAMPLES
     
     AB
    1=AND(TRUE,TRUE) = True5
    2=AND(TRUE,FALSE) = False10
    3=AND(FALSE,TRUE) = Falsesome text
    4=AND(TRUE,TRUE,TRUE) = True 
    5=AND({TRUE,TRUE}) = True 
    6=AND({TRUE,FALSE}) = False 
    7=AND({TRUE},{FALSE}) = False 
    8=AND(1,1) = True 
    9=AND(0,0) = False 
    10=AND(5<10,20>10) = True 
    11=AND(10<5,10>20) = False 
    12=AND(B1<=B2,20>=B2) = True 
    13=AND(B3,TRUE) = True 
    14=AND(TRUE,"some text") = #VALUE! 
    		 
     Functions - A | Index - A | Office Online 

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