Home › Practice questions › AND › Question 8

Excel AND Practice Question: Write All passed in E2 if every mark in B2:B6 is 40 or more, otherwise Someone…

By Rinkesh Shah, founder of Cellgrids.

The question

Write All passed in E2 if every mark in B2:B6 is 40 or more, otherwise Someone failed.

The data

	A	B	E
1	Name	Marks	Result
2	Rahul	72	?
3	Priya	65
4	Amit	40
5	Neha	58
6	Karan	91

The yellow cell is where your answer goes.

Show answer

Answer in E2: All passed

How it works

Explanation: AND can check a whole range at once. It is TRUE only when every mark passes the test.
Syntax: =IF(AND(B2:B6>=40),"All passed","Someone failed")
The lowest mark is 40, which is allowed, so every mark passes and the result is All passed.

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.