Logic › IF35 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeIF

IF: student pass status

Mrs. Wulan, a homeroom teacher, is grading the final exam. Students who score at least 75 pass, and the rest take a retake.

Task

Fill C2:C7 with the text Pass if the score (column B) is at least 75, otherwise Retake.

Cells to fillC2:C7

Required functionsIF

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
The shape of IF is IF(condition, value_if_true, value_if_false).
Hint 2
"At least 75" means 75 also passes, so use >=.
Hint 3
Text inside a formula goes in double quotes, for example "Pass". The condition: the score in B2 is at least 75 (>=).

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

C2:C7

=IF(B2>=75,"Pass","Retake")

Write it in C2, then fill down to C7.

Explanation

=IF(B2>=75,"Pass","Retake") checks one condition and picks one of two results. Common mistakes: using > so a score of exactly 75 is sent to the retake, or forgetting the quotes so Excel reads Pass as a name and returns #NAME?.

Starting worksheet: Sheet1
Row	A	B	C
1	Student	Score	Status
2	Aulia	88
3	Bima	74
4	Citra	75
5	Dewa	62
6	Eka	91
7	Fikri	79
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result