View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BrownsFan BrownsFan is offline
external usenet poster
 
Posts: 8
Default Problem calculating Using a Percentage

I have a value of 289.2 in column A and a value of 325.1 in column B.
I created the the difference in percentage by using the following
calculation (325.1 - 289.2)/289.2. The percentage in 12.4%. When I
mutliply the calculated column of 12.4% by a value in another column,
39750, I get the value 4934. This is incorrect - the value should be
4929. Can someone please help?