Home › Practice questions › IFS › Question 6

Excel IFS Practice Question: Rate each student on two marks: Star if both are 90 or more, Good if at least…

By Rinkesh Shah, founder of Cellgrids.

The question

Rate each student on two marks: Star if both are 90 or more, Good if at least one is 90 or more, Fair if both are 50 or more, otherwise Poor. Put it in D2 to D5.

The data

	A	B	C	D
1	Name	Maths	Science	Rating
2	Rahul	95	92	?
3	Priya	95	60	?
4	Amit	60	55	?
5	Neha	40	30	?

The yellow cells are where your answer goes.

Show answer

Expected results:

D2 = Star
D3 = Good
D4 = Fair
D5 = Poor

How it works

Explanation: AND and OR can be used inside the conditions of IFS. The strictest rule goes first, and the order of the rules matters.
Syntax: =IFS(AND(B2>=90,C2>=90),"Star",OR(B2>=90,C2>=90),"Good",AND(B2>=50,C2>=50),"Fair",TRUE,"Poor")
Rahul has 95 and 92: Star. Priya has one mark above 90: Good. Amit has 60 and 55: Fair. Neha has 40 and 30: Poor.

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.