IF practice

IF returns one value when a condition is TRUE and another when it is FALSE. Below are the 4 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

IF(condition, value_if_true, value_if_false)

What people get wrong

Nesting more than two or three IFs is a sign to use IFS, a lookup table or MAX and MIN instead.

Google Sheets exercises that use IF

• Over budget?Level 1Free
• Commission over a thresholdLevel 1Pro
• Codes that are too longLevel 4Pro
• Valid order IDsLevel 5Pro

Often used together with: ARRAYFORMULA, LEN, REGEXMATCH, SUM