Home
MS Office - How to ?
Excel Tutorials
Word Tutorials
PowerPoint Tutorials
Free e-books
VIDEO Tutorials
Office 2007 Guides
Excel 2007 Tutorials
PowerPoint 2007 Guides
Word 2007 Tutorials
MS Office Template
Free Clip Art
Keyboard Shortcut
Tips and Tricks
MS Outlook
MS Publisher
Free Newsletter
MS Windows
Contact Us
Site Map
Google Docs and ...
You and This Site
Resources Page

XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google
 


Excel OR Function


The Excel OR function returns TRUE if one condition are TRUE. It returns FALSE if all of the conditions are FALSE.

To determine whether the output will be TRUE or FALSE, the function evaluates at least one mathematical expression located in another cell in the spreadsheet.

The syntax for the OR function is:

=OR (Condition1, Condition2, ...)
condition is something that you want to test that can either be TRUE or FALSE.

To use the OR( ) function (an example)

  • Type in the number in cells C1 and C3 as follow:

    Excel OR function data

  • Click on cell C5 where the results will be displayed.
  • Type =OR(C1>500, C2>500, C3>500) in cell C5
  • Once finish, press the Enter key on the keyboard.
  • The answer TRUE appears in cell C5.

    Note: If any of these three cells (C1,C2, or C3) contains a value greater than 500, the output for the OR function in cell C5 will be TRUE. If all three cells have numbers less than or equal to 500, the output will be FALSE.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    Recommended book:

    Revealed! 101 Excel Secrets Revealed! 101 Excel Secrets


    You're viewing the Excel OR Function info page, click here to go back to the Home Page


    footer for excel OR function page

    		•