Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i add figures exactly, do not round up.
My figures are calculated to 2 decimal places but when I add them up they add
up to more as the figure has been rounded up. I want to send this spreadsheet to Customs and Excise so it must be correct |
#2
|
|||
|
|||
Add the pre-rounded numbers, and then round them to 2 places.
-- HTH Bob Phillips "hitch" wrote in message ... My figures are calculated to 2 decimal places but when I add them up they add up to more as the figure has been rounded up. I want to send this spreadsheet to Customs and Excise so it must be correct |
#3
|
|||
|
|||
hitch wrote:
My figures are calculated to 2 decimal places but when I add them up they add up to more as the figure has been rounded up. I want to send this spreadsheet to Customs and Excise so it must be correct I wouldn't worry. As long as the answer is to the nearest penny or pound (whichever) C&E aren't going to be bothered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hi-lighting figures | Excel Discussion (Misc queries) | |||
Why does Excell round-off figures when adding them? | Excel Discussion (Misc queries) |