Menu
EXCEL OR FUNCTION
Excel OR Function Introduction
If all of its inputs are false, the OR function returns FALSE, and if one or more of them are true, it returns TRUE. As an example, if a salesperson exceeds the dollar sales budget or the unit sales budget, you may wish to reward her with a bonus. This is known as an Or condition in Boolean logic.
Description of Excel OR Function
Syntax:
=OR (logical1, [logical2], …)
Parameter list:
- The first condition or logical value to test is logical1.
- logical2 – the second condition or logical value to check (optional).
Step By Step Guide of OR Function
- Because one of the arguments is TRUE, the result will be TRUE.
- =OR(2+2=1,2+8=5) returns FALSE because both arguments are incorrect: 2+2 is not 1 and 2+8 is not 5.
- The result of =OR(TRUE,FALSE,TRUE) is TRUE. TRUE is one of the arguments.
- Because one of the arguments is true, =IF(OR(3+1=1,2+9=5,5+15=20),“Correct”, “Not Correct”) will result in the response Correct.
- You are layering it with another function IF in this case so that you may specify your own words as an answer, in this example Correct, or if you want to receive an answer of YES, use the word YES instead of Correct.
Key Points
- The parameters must evaluate to logical values like TRUE or FALSE, or to logical values in arrays or references.
- Text or empty cells are disregarded if an array or reference parameter contains them.
OR returns the #VALUE! error value if the supplied range has no logical values in it. - To check if a value appears in an array, use the OR array formula. To create an array formula Press CTRL+SHIFT+ENTER.
Excel OR Function Template/Exercise
- Download OR Function Template
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
