Menu
Coddy logo textTech

Recap: Service Invoice

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 5 of 28.

challenge icon

Challenge

Medium

Hours 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

Sheet1
ABCDEFG
1JobHoursRateChargeSurcharge
2A212.50.1
3B39.75
4C118
5
6Total
7
8
9
10
11
12
13
14

All lessons in Formulas and Data Analysis

Practice on your own: Excel playground