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

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

 
 Returns the logical "OR" for any number of arguments.

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

 REMARKS
 
  		• The arguments must evaluate to logical values such as True or False, or in arrays or references that contain logical values.
     
  		• If an array or reference argument contains text or empty cells, those values are ignored.
     
  		• If the specified range contains no logical values, OR returns the #VALUE! error value.
     
  		• You can have a maximum of 30 arguments.

     EXAMPLES
     
     A
    1=OR(TRUE) = True
    2=OR(1+1=1,2+2=5) = False
    3=OR(FALSE,FALSE,FALSE,TRUE) = True
    4=OR(1,1,0,0,0,1,1) = True
    5=OR({FALSE,FALSE,FALSE}) = False
    6=OR({TRUE,FALSE}) = True
    7=OR({FALSE},{FALSE}) = False
    8{=OR({FALSE,FALSE},{TRUE,TRUE})} = TRUE
    		 
     Functions - O | Index - O | Office Online 

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