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
|