Home › Practice questions › IFS › Question 9

Excel IFS Practice Question: Scores are in B2:B7. Grade them in D2:D7: 90 and above is A, 75 and above is…

By Rinkesh Shah, founder of Cellgrids.

The question

Scores are in B2:B7. Grade them in D2:D7: 90 and above is A, 75 and above is B, 60 and above is C, below 60 is D.

The data

	A	B	D
1	Student	Score	Grade
2	Aarav	93	?
3	Diya	78	?
4	Ishaan	61	?
5	Kavya	45	?
6	Rohit	88	?
7	Tanvi	72	?

The yellow cells are where your answer goes.

Show answer

Expected results:

D2 = A
D3 = B
D4 = C
D5 = D
D6 = B
D7 = C

How it works

Explanation: IFS tests conditions in order and returns the result of the first true one. TRUE at the end works as the catch-all for everything else.
Syntax: =IFS(B2>=90,"A",B2>=75,"B",B2>=60,"C",TRUE,"D")
93 is A, 78 is B, 61 is C, 45 is D, 88 is B and 72 is C.

Try it yourself in the live sheet

Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.

Try this question in the live sheet →

IFS syntax

=IFS(logical_test1, value1, [logical_test2, value2], ...)

Checks multiple conditions in order and returns the value for the first one that's true. IFS is used to build decision rules directly into a spreadsheet instead of manually judging each row. Full IFS guide.