Logic › IFS14 / 67

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

MediumFreeIFS

IFS: report card grades

Mrs. Melati, a grade 8 homeroom teacher at a junior high school in Bogor, is filling in digital report cards. Her school uses grades A to D based on the final score, following the table next to the data.

Task

In C2:C9, assign each student a grade with IFS: 90 and above A, 80 to below 90 B, 70 to below 80 C, otherwise D. Write it in C2 and copy it down to C9.

Cells to fillC2:C9

Required functionsIFS

Expected result

Loading the expected result…

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

Hint 1
IFS checks condition and result pairs from left to right, and stops at the first condition that is true.
Hint 2
Start from the highest limit: B2>=90 first, then B2>=80, and so on.
Hint 3
For "otherwise", use TRUE as the last condition: =IFS(B2>=90,"A", …, TRUE,"D").

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:C9

=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",TRUE,"D")

Write it in C2, then fill down to C9.

Explanation

Because IFS stops at the first true condition, a score of 92 gets A right away without being checked against >=80. If the order is reversed (starting with >=70), every score of 70 or more becomes C. IFS has no default value, so without the TRUE,"D" pair at the end, a score of 65 returns #N/A. Also note that 79.5 stays C because it has not reached 80.

Starting worksheet: Sheet1
Row	A	B	C	E	F
1	Name	Final score	Grade	Minimum score	Grade
2	Rafi	92		90	A
3	Nabila	80		80	B
4	Kevin	79.5		70	C
5	Aulia	70		0	D
6	Daffa	65
7	Zahra	88
8	Farel	90
9	Keisha	58
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result