IF for every row
PremiumIn C2, use ARRAYFORMULA with IF to write "Pass" for every score of 50 or more and "Fail" for the rest.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Student | Score | Result | |||
| 2 | Ann | 72 | ||||
| 3 | Bo | 45 | ||||
| 4 | Cy | 88 | ||||
| 5 | Di | 51 | ||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock ARRAYFORMULA and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:SPLIT and JOINREGEX functions
Need help?
Why this works
Inside ARRAYFORMULA, B2:B5>=50 gives TRUE or FALSE for each score, and IF turns each one into Pass or Fail. One formula in C2 writes all four results.
Common mistake: Putting ARRAYFORMULA inside the IF. It goes on the outside, around the whole formula.
The answer
- C2
=ARRAYFORMULA(IF(B2:B5>=50,"Pass","Fail"))