Skip to main content

IF with OR: either condition is enough

50%
IFOR

OR is true as soon as any one of its tests is true. It is the natural fit for exception reporting, where you want to catch a row for any of several reasons rather than only when everything goes wrong at once.

Shipping took too long, or the cost is unusually high. Either on its own is worth a look.

In D2, show Review when delivery took more than 5 days or the cost is over 500, and OK otherwise. Then fill D2 down to D6.

The grid for this exercise needs a free profile.

Everything above is yours to read either way. 19 exercises stay open with no profile at all.