AND
Returns TRUE only if every test passes.
How it’s written
AND(test1, test2)Example
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Amara | 72 |
| 3 | Ben | 90 |
| 4 | Chloe | 65 |
| 5 | Dev | 90 |
| 6 | Elena | 83 |
=AND(B3>=80,B6>=80)Result: TRUE
Both Ben’s and Elena’s scores are at least 80.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Use it as the test inside an IF.
Practice it properly
Rules with several parts gives you real tasks, with your formulas tested on data you haven’t seen.