The OR function
The OR function is one of the most important logical functions in excel 😯
The OR function in Excel returns True if at least one of the criteria evaluates to true.
If all the arguments evaluate as False, then the OR function returns False.
The syntax of the OR function in Excel is OR(logical1, [logical2], …).
Assume that employees are eligible for an incentive if they achieve a value or volume target of 75% or more 🏆
Let’s try OR function for the above example.
- Enter an equal sign and select the OR function.
You will see below in the formula bar.
- Supply the first logical value to evaluate as the first argument.
You can write logical values to test using logical operators.
In this case, we want to first test, whether the value target achievement is greater than or equal to 75%.
So, we can give the cell reference and write the condition >=75%.
Now the formula is,
- Enter a comma and enter the 2nd logical value for the logical test.
Then, we enter the logical value for the volume target.
Now, the updated formula is;
- Close the parentheses and press enter.
The below Excel formula evaluates arguments.
Then returns true if at least one of the value or volume target achievements is greater than or equal to 75%. If both value and volume target achievements are below 75%, the OR function returns False.