View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default per centages and sums error

DebC wrote:
In excel 2003, I need to calculate per centages of a number, and add the
sums of each together. The results may be off a penny or two each time. Can
someone help?
example: if you multiple $4,675.00 by .05%, and then by .5%
$4,675.00
x .05% = $2.34
x .5% = $23.38

sum $25.71

I assume it is a formatting issue, but I am at a loss. Seems like it
should be simple. Thanks for any help!


Wrap your formulas with ROUND().

=ROUND(A1*.05%,2)