← All exercises

Unpaid invoices

Unpaid invoices: nested IFs & IFS

Flag unpaid invoices and calculate the balance due using logical tests, a nested IF and the IFS function — 10 guided steps, write each formula then fill it down.

Write the formula in cell D2

1 / 10

Test: is the invoice unpaid?

2 / 10

Fill down the test (column D)

Write the formula in cell E2

3 / 10

Test: amount paid = invoiced amount?

4 / 10

Fill down the test (column E)

Write the formula in cell F2

5 / 10

IF: "KO" if unpaid, otherwise empty

6 / 10

Fill down the IF (column F)

Write the formula in cell G2

7 / 10

Nested IFs: KO / difference / empty

8 / 10

Fill down the nested IFs (column G)

Write the formula in cell H2

9 / 10

Same result with IFS

10 / 10

Fill down IFS (column H)

Your score is

0%