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)

Lorenzo

Silver Contributor

Jun 02, 2023

Hi Davec62

in E2 (and copy down): =ROUND(C2/1.2,2)

(D2 can be simplified as: =C2-E2)