Home › Practice questions › IFS › Question 1

Excel IFS Practice Question: Write A for marks 90 or more, B for 60 or more, otherwise C. Put the grade in…

By Rinkesh Shah, founder of Cellgrids.

The question

Write A for marks 90 or more, B for 60 or more, otherwise C. Put the grade in C2 to C4.

The data

	A	B	C
1	Name	Marks	Grade
2	Rahul	92	?
3	Priya	65	?
4	Amit	40	?

The yellow cells are where your answer goes.

Show answer

Expected results:

C2 = A
C3 = B
C4 = C

How it works

Explanation: IFS checks the conditions one by one and gives the result of the first one that is TRUE. TRUE at the end works as the else part.
Syntax: =IFS(B2>=90,"A",B2>=60,"B",TRUE,"C")
92 is 90 or more: A. 65 is 60 or more: B. 40 matches neither, so TRUE gives 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.