AND practice

AND returns TRUE only when every condition is TRUE. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.

Syntax

AND(condition1, [condition2], ...)

What people get wrong

AND does not short-circuit: every argument is evaluated, so an error in any of them makes the whole result an error.

Excel exercise that use AND

• Bonus for the northLevel 2Pro

Often used together with: IF