Home › Practice questions › AND › Question 4

Excel AND Practice Question: Write Ship if the status is Paid, the quantity is above 0 and the stock is In…

By Rinkesh Shah, founder of Cellgrids.

The question

Write Ship if the status is Paid, the quantity is above 0 and the stock is In stock. Otherwise write Hold. Put it in E2 to E4.

The data

	A	B	C	D	E
1	Order	Status	Qty	Stock	Action
2	A101	Paid	5	In stock	?
3	A102	Paid	0	In stock	?
4	A103	Pending	2	In stock	?

The yellow cells are where your answer goes.

Show answer

Expected results:

E2 = Ship
E3 = Hold
E4 = Hold

How it works

Explanation: AND can check three or more conditions. All of them must be true to ship.
Syntax: =IF(AND(B2="Paid",C2>0,D2="In stock"),"Ship","Hold")
A101 passes all three tests: Ship. A102 has quantity 0: Hold. A103 is Pending: Hold.

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.