Free practice · Hands-on spreadsheet · medium
Practice
Apply a two-condition eligibility rule
In D2, return "Eligible" only when B2 is at least 80 and C2 is "Complete"; otherwise return "Review".
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 |
Free practice · Hands-on spreadsheet · medium
Apply a two-condition eligibility rule
In D2, return "Eligible" only when B2 is at least 80 and C2 is "Complete"; otherwise return "Review".
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 |