Home › Practice questions › AND › Question 2

Excel AND Practice Question: A person is eligible if the age is 18 or more and the city is Pune. Write…

By Rinkesh Shah, founder of Cellgrids.

The question

A person is eligible if the age is 18 or more and the city is Pune. Write Eligible or No in D2 to D4.

The data

	A	B	C	D
1	Name	Age	City	Result
2	Rahul	25	Pune	?
3	Priya	17	Pune	?
4	Amit	30	Surat	?

The yellow cells are where your answer goes.

Show answer

Expected results:

D2 = Eligible
D3 = No
D4 = No

How it works

Explanation: Both tests must be true. If the age or the city fails, AND gives FALSE.
Syntax: =IF(AND(B2>=18,C2="Pune"),"Eligible","No")
Rahul is 25 and in Pune: Eligible. Priya is 17: No. Amit is not in Pune: No.

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.