Home › Practice questions › AND › Question 5

Excel AND Practice Question: Write Average if the marks are between 40 and 60 (both included), otherwise…

By Rinkesh Shah, founder of Cellgrids.

The question

Write Average if the marks are between 40 and 60 (both included), otherwise Other. Put it in C2 to C4.

The data

	A	B	C
1	Name	Marks	Band
2	Rahul	55	?
3	Priya	72	?
4	Amit	40	?

The yellow cells are where your answer goes.

Show answer

Expected results:

C2 = Average
C3 = Other
C4 = Average

How it works

Explanation: A range test needs two conditions on the same cell: not below 40 and not above 60.
Syntax: =IF(AND(B2>=40,B2<=60),"Average","Other")
55 is inside the range: Average. 72 is above 60: Other. 40 is the lowest allowed value: Average.

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 →

AND syntax

=AND(logical1, [logical2], ...)

Returns TRUE only if every condition given is true. AND is used to build decision rules directly into a spreadsheet instead of manually judging each row. Full AND guide.