How To Use Excel OR Function

    how to use excel or function

    Quick Intro

    By using Excel OR Function you can check multiple conditions. It will return true if any of those conditions is true, else it will return false.

    In simple words, if a single condition is true from all those conditions which you are testing it will return TRUE. That means at least one condition needs to be TRUE to get TRUE in the result.

    Defination for Excel OR Function

    In above example, I have used or function to check multiple conditions. The formula has returned TRUE even a single condition is TRUE and FALSE if all the conditions are FALSE.

    Syntax

    OR(logical1, [logical2], …)

    • logical1 Condition which you want to verify.
    • [logical2] Additional Conditions you want to verify.

    More Information on Excel OR Function

    • Values will be ignored if reference cell or array contained an empty cell or text.
    • The result of conditions should be in logical value (TRUE or FALSE).
    • It will return an error if there is no logical value is returned.
    • The maximum numbers of values you can test are 255.

    Examples

    In the below example, we have created a condition using IF Function that if a student score 60 above marks in one of the both subjects the formula returns TRUE.

    Examples For Excel OR Function

    You can also use OR Function to work with numbers as well. As you know TRUE & FALSE has values 0 & 1 respectively.

    In the below example, I have used a number to get logical values in a formula. You can also perform above condition in reverse order. You can use TRUE & FALSE instead of numbers. OR Function treats these logical values as numbers.

    Examples For Excel OR Function

     

    Sample File

    download sample file to learn more about this tips

    Related Tip

    What’s Next?

    To learn more about Excel OR Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There is also you have AND function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.