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

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