Forum Discussion

Copper Contributor

Jun 02, 2023

Solved

Excel Rounding On =SUM

Hi I have created spreadsheet which calculates VAT and has a total columns. The issue is that the numbers are rounded up or down. I would like them to be exact. I have =sum(D2:D4) which are...

Expenses and Income Spreadsheets Revised - Nov 22.xlsx15 KB

excel

Formulas and Functions

Lorenzo
Jun 02, 2023
Hi Davec62

in E2 (and copy down): =ROUND(C2/1.2,2)
(D2 can be simplified as: =C2-E2)

SergeiBaklan

Diamond Contributor

Jun 02, 2023

Davec62

Totals are not rounded, they are exact

If you'd like to round intermediate values, then as Lorenzo suggested. Format itself rounds nothing, it only display not rounded value in the way you defined.

Davec62

Copper Contributor

Jun 02, 2023

SergeiBaklan

thanks for your additional input

Dave