# Invoice status with nested if

*Note: the "current date" (i.e. today) for this example is May 31, 2016*

With nested IF statements, the flow is from outer IF statements to inner IF statements, and the challenge is always to construct the flow so that the formula returns a logically correct result.

Here, the outermost IF tests first to see if the balance is zero:

=IF(F5=0

If TRUE, the formula returns "Paid".

If not, the result of the first IF is FALSE, and another IF statement is run. This one checks to see if TODAY() is less than the due date in column C:

If TRUE, the formula returns "Open".

If FALSE, the formula returns "Overdue".

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

## Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.