October 28, 2025
How to Use IF + OR in Excel?
4.9 (85)
Combine the IF and OR functions to test multiple conditions in a spreadsheet program.
Related reading
Excel Keyboard Shortcuts – Boost Your Productivity
Mastering keyboard shortcuts can dramatically speed up your workflow in Excel. These shortcuts are divided into two main categories: Cell Formatting and Other Important Shortcuts.
A sparkline is a small chart located inside a single cell that displays data trends, such as seasonal ups and downs, cycles, or highs and lows. They are best placed near the data they represent. How to Add a Sparkline
➤ How the Functions Work
- IF function: Checks a condition and returns a value if TRUE or a different value if FALSE.
- OR function: Tests multiple conditions and returns TRUE if at least one condition is TRUE.
➤ Example Goal
Mark employees as "Bonus Eligible" if their salary is more than $50,000 OR their experience is above 5 years.
➤ Example Data and Results
- Alex: Salary $48,000 (not > 50,000), Experience 6 years (is > 5) → Bonus Eligible
- Bella: Salary $55,000 (is > 50,000), Experience 4 years (not > 5) → Bonus Eligible
- Chris: Salary $42,000 (not > 50,000), Experience 3 years (not > 5) → Not Eligible
💡 Pro Tips
- Use OR when only one condition needs to be true.
- Use AND when all conditions must be true.