Lab › Dates & Times › Library Late Fee
Library Late Fee: Excel Lab
Lab 20 · IntermediateDate subtractionMAX$ absolute reference
The task: Books returned after the due date pay 10 per day. Books returned early or on time pay nothing.
1 Watch how it is done
Step 1: Days late (never below 0)
=MAX(0,C4-B4)- Click D4.
- Type =MAX(0,C4-B4) and press Enter. MAX with 0 turns early returns into 0.
- Drag the fill handle down.
Step 2: Fine = days late × fine per day
=D4*$G$4- Click E4.
- Type =D4*$G$4 and press Enter.
- Drag the fill handle down.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Fix #DIV/0! with IFERROR →
Want the theory? Read the Dates & Times lessons →
← More Dates & Times labs · All lab categories
