Thread: Rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Rounding

Hi!

Actually, there is not a problem and Excel is calculating these properly.

The difference is the result of the ROUND function.

Not rounded: (to 15 decimal places)

3348.86*0.1=334.886000000000000
3348.86*0.03=100.465800000000000

Added together = 435.351800000000000

Biff

"Bud" wrote in message
...
I would really like some help,

round(3348.86*.1,2) = 334.89
round(3348.86*.03,2) = 100.47
when added together 334.89+100.47 = 435.36
yet
round(3348.86*.13,2) = 435.35

I beleive it is because 100.4658 is rounding to 100.47, when it should be
100.46.

I really need these numbers to add up. If this is possible it would be
great. Thank you