How to Round to Two Decimal Places in Excel
Open your Excel workbook (.xlsx) in Cue Office. If you need to round each charge to two decimal places before adding them up, use ROUND on each row’s hours times the rate, then add the rounded charges with SUM.
Round each charge, then add the results
In this workshop expense sheet, column B holds Hours and column C holds Rate. Use column D for the rounded charges and keep the original amounts in column E for comparison.
Select D2 and paste all five lines below into the sheet. The first four formulas calculate the rounded charges in D2:D5. The last formula adds them in D6. The second argument of ROUND, 2, sets the number of decimal places.
=ROUND(B2*C2,2) =ROUND(B3*C3,2) =ROUND(B4*C4,2) =ROUND(B5*C5,2) =SUM(D2:D5)
Check one charge and one credit. The formula rounds 10.625 to 10.63 and −10.625 to −10.63. Save and reopen the workbook. D6 should show a rounded total of 33.13 and E6 a raw total of 33.125.
Why doesn't the total change after formatting to two decimal places?
If you only need line items to display with two decimal places, select E2:E5 and choose Number from the number format menu on the Home toolbar. Cell E6, left in General format, still sums the underlying raw values, so its total remains 33.125.
To see when rounding each charge affects the total, temporarily change the hours in B2 to 1.03125 in a copy. D2 rounds to 20.63 and E2 holds the raw amount, 20.625. D6 now totals 31.26 and E6 totals 31.25, a difference of 0.01. Restore B2 when you finish checking.
Have Cue AI calculate the charges and total
Use a copy of the workbook with D2:D6 still blank. Select A1:E6, open Cue AI from the Home toolbar, and send the prompt below.
Can you work out the charges on Sheet1? Multiply Hours by Rate for each row, round each charge to two decimal places, and put those calculations in D2:D5. Then add up the rounded charges in D6. Use formulas so the amounts update when I change the hours or rate, and leave the headers, source data, and Raw charge formulas in column E as they are.
Cue AI wrote four ROUND formulas in D2:D5 and a SUM formula in D6. Save and reopen the copy. Select D3 to check that it uses B3 and C3, then select D6 to confirm it sums D2:D5. Compare both totals with the figure below.
Practice with the event expense sheet
Show the full example
Create a spreadsheet in Cue Office and paste the practice data into A1. Column E calculates the raw charges. Column D has room for the five formulas above.
Item Hours Rate Rounded charge Raw charge Room setup 1.125 20 =B2*C2 Printing prep 1.0625 10 =B3*C3 Sign-in desk 1.0625 10 =B4*C4 Setup credit -1.0625 10 =B5*C5 Total =SUM(E2:E5)
Reconcile a one-cent difference
When you review charges for the next workshop, ask Cue AI to write the rounding and total formulas in a copy of the expense sheet. If the totals differ, as 31.26 and 31.25 do in this example, multiply the hours by the rate for one line and check its rounded amount. Add each column separately, then check your reimbursement policy to see which total to use.
In Cue Office, open the PDF receipts (.pdf) for free to check the rates, then correct any entry errors in the Excel expense sheet (.xlsx). If you need to explain the difference, record the rounding rule in your Word reimbursement notes (.docx) and put both totals on a PowerPoint recap slide (.pptx). Cue Office lets you edit those three Office formats for free.