ExcelHeroThe OR function
TRUE if at least one test is true.
In German Excel: ODER
How to write it
=OR(logical1, [logical2], …)- logical1
- The first test.
- logical2
- More tests.
💡 OR(A2="Sat",A2="Sun") checks for a weekend.
Try it
Is Omar in Tech, or has Omar worked more than 5 years?
A
B
C
D
E
1
Name
Team
Salary
Years
Check
2
Nora
Sales
52000
3
3
Omar
Support
41000
1
4
Priya
Sales
61000
6
5
Quinn
Tech
72000
4
6
Rosa
Support
39000
2
7
Sven
Tech
80000
8
=OR(test one, test two).