IF that returns a number
Exercise 5 of 11 Premium
Add 5 bonus points to Liam's Science score if his attendance is 80% or more. Otherwise keep his score as it is.
Checking your plan…
class-results.xlsx
ABCDE
1StudentMathEnglishScienceAttendance
2
3
4
5
6
7
8
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.Pass or fail
- 2.Needs a retake
- 3.Attendance warningPremium
- 4.Strong in every subjectPremium
- 5.IF that returns a numberPremium
- 6.Flag students for supportPremium
- 7.Average inside IFPremium
- 8.Nested IFPremium
- 9.Letter gradesPremium
- 10.Add up TRUEsPremium
- 11.AND with an averagePremium