Recap: Service Invoice
Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 5 of 28.
Challenge
MediumHours are in B2:B4, hourly rates in C2:C4, and a shared surcharge fraction in G2. In D2:D4, calculate each hours-times-rate charge with the surcharge, rounded to two decimals. In D6, sum the rounded charges.
Enter formulas in the highlighted output cells: D2, D3, D4, D6. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.
Try it yourself
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Job | Hours | Rate | Charge | Surcharge | ||
| 2 | A | 2 | 12.5 | 0.1 | |||
| 3 | B | 3 | 9.75 | ||||
| 4 | C | 1 | 18 | ||||
| 5 | |||||||
| 6 | Total | ||||||
| 7 | |||||||
| 8 | |||||||
| 9 | |||||||
| 10 | |||||||
| 11 | |||||||
| 12 | |||||||
| 13 | |||||||
| 14 |
All lessons in Formulas and Data Analysis
1Reusable Formulas
Relative ReferencesAbsolute ReferencesMixed ReferencesRounding ResultsRecap: Service Invoice5Cleaning Imported Data
TRIM SpacesSUBSTITUTE TextFinding a DelimiterConverting Numeric TextRecap: Imported LabelsPractice on your own: Excel playground