IF practice

IF returns one value when a condition is TRUE and another when it is FALSE. Below are the 5 Excel exercises on Formuladrill 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.

Excel exercises that use IF

• Pass or failLevel 2Pro
• Letter gradesLevel 2Pro
• Bonus for the northLevel 2Pro
• Flag for reviewLevel 2Pro
• Flag duplicate ordersLevel 6Pro

Often used together with: AND, COUNTIF, OR