AND practice

AND returns TRUE only when every condition is TRUE. Below are the 1 Google Sheets exercise on Sheetsdrill 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.

Google Sheets exercise that use AND

• Free shipping ruleLevel 2Pro

Often used together with: IF, OR