IFS practice

IFS checks several conditions in order and returns the value for the first one that is TRUE. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.

Syntax

IFS(condition1, value1, [condition2, value2], ...)

What people get wrong

Order matters: put the strictest condition first, and end with TRUE as a catch-all to avoid #N/A.

Excel exercise that use IFS

• Shipping tiersLevel 2Pro