IF practice

IF returns one value when a condition is TRUE and another when it is FALSE. Below are the 3 financial modeling exercises on Modeldrill 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.

financial modeling exercises that use IF

• Straight-line depreciation by assetLevel 2Pro
• Depreciation from the year of purchaseLevel 2Pro
• Debt service coverage testLevel 3Pro

Often used together with: AND, SUM