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.

A worksheet listing four entries with hours and rates, column D blank, and column E showing raw products
Enter the formulas under Rounded charge. Use Raw charge to check the unrounded amounts.

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.

Formula bar for D3 shows =ROUND(B3*C3,2), with a rounded total of 33.13 and a raw total of 33.125 in the table
Selecting D3 lets you verify in the formula bar that it references the hours and rate from the same row.

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.

Raw charge line items display 22.50, 10.63, 10.63, and -10.63, E6 displays 33.125, and the formula bar shows =SUM(E2:E5)
E2:E5 display two decimal places, while the formula in E6 still sums the unrounded values to produce 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.

The Cue AI button on the Home toolbar and the open sidebar; opening the full image shows the A1:E6 selection.
Open Cue AI from the Home toolbar. The selection in this example is A1:E6.
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.

The reopened workbook shows four rounded charges alongside the raw charges, with totals of 33.13 and 33.125.
After reopening the workbook, spot-check D3 in the formula bar, then compare the two column totals.

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.

Download Cue Office for free