IFS practice

IFS checks several conditions in order and returns the value for the first one that is TRUE. Below are the 1 Google Sheets exercise on Sheetsdrill 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.

Google Sheets exercise that use IFS

• Customer tiers with IFSLevel 2Pro