Logicbeginner

The IF Function

Make decisions in your spreadsheet: test a condition and return one value if it's true, another if it's false.

Read the full guide to The IF Function in Excel →

0 of 3 exercises complete

Pass or fail

In cell C2, write a formula that shows "Pass" if the score in B2 is 60 or more, otherwise "Fail". Use =IF(B2>=60,"Pass","Fail").

A failing case

Copy the same kind of logic into C3 for a student who scored below 60 — it should show "Fail".

Nested IF for a bonus tier

In cell C2, give a bonus level: "Gold" if sales (B2) are over 1000, "Silver" if over 500, otherwise "Bronze". Use =IF(B2>1000,"Gold",IF(B2>500,"Silver","Bronze")).