FormulaCamp
Completed
4. Excel Functions · Logic · 15 min

7. The IF Function

Lesson 7 of 25
Task 1 of 1
  1. In C2:C8, write "Pass" if the score is at least the passing score (F1), otherwise "Fail".

Lesson theory

=IF(condition, if true, if false). For example: =IF(B2>=60, "Pass", "Fail").

Text goes in quotation marks. Comparison operators: >, <, >=, <=, =, <> (not equal).

fx

Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo

Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page