Quantunet.com

My Account

Joins Us
Excel QuickSkills
The OR() Function Knowledgebase  

 

The OR() function returns a logical value of TRUE if any one of its arguments have a logical value of TRUE.

  • The syntax for the function is OR (logical).

Where "logical 1" represents the logical value of the first arguments of the function. If one of the arguments has a logical value of TRUE then the OR function will return a logical value of TRUE to the cell.
For example : OR (FALSE, FALSE, TRUE, FALSE, TRUE, FALSE) = TRUE

If all the arguments in the function have a logical value of FALSE then the OR function returns a logical value of FALSE. e.g: OR (FALSE, FALSE, FALSE, FALSE, FALSE) = FALSE.


How to use the OR() function:

  • Type " =OR( "
  • Enter the coordinate of the first data cell "A2"
  • Type a colon:
  • Enter the coordinate of the last data cell "A8"
  • Then press the "Enter" or "Tab" key.


 





© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us