OR function - Microsoft Support
Technical Details. Examples. Here are some general examples of using OR by itself, and in conjunction with IF. Sales Commission Calculation. Here is a fairly common scenario where we need to calculate if sales people qualify for a commission using IF and OR.
more