Checking invoices
Exercise 1 of 4
In F5, look up the customer for INV-204's code in the customer list (G:H). Its code isn't in the list, so show "unknown".
About this lesson
Invoices, a customer list and a report date. Look up names, flag overdue invoices and total what is still unpaid.
In this lesson
- In
F5, look up the customer for INV-204's code in the customer list (G:H). Its code isn't in the list, so show "unknown". - An invoice is overdue when it isn't paid and its due date is before the report date in
K1. InF3, show "overdue" for INV-202 if it is, and nothing otherwise. - In
K2, add up the amounts of all unpaid invoices. - In
K3, count the overdue invoices: unpaid, with a due date before the report date in K1.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in F5 and press Enter to check.