Home › Practice questions › AND › Question 1

Excel AND Practice Question: A student passes only if both subject marks are 50 or more. Write Pass or Fail…

By Rinkesh Shah, founder of Cellgrids.

The question

A student passes only if both subject marks are 50 or more. Write Pass or Fail in D2 to D4.

The data

	A	B	C	D
1	Name	Maths	Science	Result
2	Rahul	72	65	?
3	Priya	80	45	?
4	Amit	50	50	?

The yellow cells are where your answer goes.

Show answer

Expected results:

D2 = Pass
D3 = Fail
D4 = Pass

How it works

Explanation: AND is TRUE only when both conditions are true. IF then shows Pass or Fail.
Syntax: =IF(AND(B2>=50,C2>=50),"Pass","Fail")
Rahul has 72 and 65, so Pass. Priya has 45 in Science, so Fail. Amit has 50 and 50, so Pass.

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.