AND practice

AND returns TRUE only when every condition is TRUE. Below are the 1 financial modeling exercise on Modeldrill 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.

financial modeling exercise that use AND

• Depreciation from the year of purchaseLevel 2Pro

Often used together with: IF