AND and OR
Test whether every condition or any condition is true
0 of 3 done · Lesson 13 of 18
Understand
A hiring manager approves candidates only when they clear the test and submit a portfolio. Other reviews begin when either the risk is high or the score is low. AND handles every condition; OR handles any condition.
=AND(first condition, next condition, optional)
=OR(first condition, next condition, optional)
A worked example
=IF(OR(B4>=80, C4="Yes"), "Approve", "Hold")
first conditionnext condition
B4 is 55 and C4 is No, so this returns Hold
The sheet you are working with
| Row number | A | B | C | D |
|---|---|---|---|---|
| 1 | Candidate | Test score | Portfolio | Risk |
| 2 | Amelia | 86 | Yes | Low |
| 3 | Hemi | 78 | Yes | Medium |
| 4 | Priya | 55 | No | High |
| 5 | Leo | 91 | No | Low |
| 6 | Sofia | 82 | Yes | Medium |
| 7 | Noah | 69 | Yes | High |