Pass or fail

BeginnerSkip →
Exercise 1 of 11IF

Did Emma pass Math? The pass mark is 50. Return "Pass" or "Fail".

Write your formula in the green cell, H2.

Logic

Pass or failNeeds a retakeAttendance warningStrong in every subjectIF that returns a numberFlag students for supportAverage inside IFNested IFLetter gradesAdd up TRUEsAND with an average
class-results.xlsx
fx
1StudentMathEnglishScienceAttendance
2Emma82917796%Emma, Math
3Liam45625881%
4Olivia93889599%
5Noah67497288%
6Ava58746192%
7Ethan39554770%
8Mia76816994%
9Lucas88599085%
10
11

Click a cell to add it to your formula, drag to select a range, or click a column letter for the whole column.

About logic in Excel

IF is the formula that makes decisions: pass or fail, over or under budget, yes or no. Practice IF on its own, then combine it with AND and OR, and finish with IFS for grading-style rules with several outcomes.

GuideHow to Use the IF Function in Excel→

Functions you can use here

  • IF(logical_test, value_if_true, [value_if_false])
  • AND(logical1, [logical2], …)
  • OR(logical1, [logical2], …)
  • IFS(logical_test1, value_if_true1, …)

More logic exercises

  1. 1.Pass or fail
  2. 2.Needs a retake
  3. 3.Attendance warningPremium
  4. 4.Strong in every subjectPremium
  5. 5.IF that returns a numberPremium
  6. 6.Flag students for supportPremium
  7. 7.Average inside IFPremium
  8. 8.Nested IFPremium
  9. 9.Letter gradesPremium
  10. 10.Add up TRUEsPremium
  11. 11.AND with an averagePremium
See the whole topic →