BeginnerExcel Basics
Work out gross margin per order
Subtract cost from revenue to find what each order actually earned.
3 min10 points
Work out remaining leave days
The situation
Harbor Supply's holiday tracker records what each employee is entitled to and what they have booked, but not what is left. People keep emailing HR to ask, and HR keeps working it out on a calculator.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Employee | Entitlement | Taken | Remaining | |
| 2 | Dana Whitfield | 25.00 | 11.00 | ||
| 3 | Marcus Bell | 22.00 | 18.00 | ||
| 4 | Priya Raman | 28.00 | 6.00 | ||
| 5 | Tom Alvarez | 22.00 | 22.00 | ||
| 6 | Sara Kim | 25.00 | 9.00 | ||
| 7 |