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?

Problem calculating Using a Percentage
 

Actually, it is the correct amount. You are using the calculated column of
12.4%, but this is just what is visible. Unless you use rounding, the value
of 12.4% is still actually 12.4135546% etc.
--
John C


"BrownsFan" wrote:

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?

Problem calculating Using a Percentage
 

<The percentage in 12.4%.

No, the percentage is 12.413554634717%. The multiplication results in 4934.3879668498.
You just formatted the cells to show less decimals.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"BrownsFan" wrote in message ...
|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?

Problem calculating Using a Percentage
 

On Aug 4, 2:44*pm, John C <johnc@stateofdenial wrote:
Actually, it is the correct amount. You are using the calculated column of
12.4%, but this is just what is visible. Unless you use rounding, the value
of 12.4% is still actually 12.4135546% etc.
--
John C



"BrownsFan" wrote:
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?- Hide quoted text -

- Show quoted text -

John,

Got it! Thanks alot. I never used the "Rounding function" before.

Problem calculating Using a Percentage
 

Try:
=ROUND((325.1 - 289.2)/289.2,3)

to get a rounded 12.4 percent if you want to cut off the extra decimal
places this way. Note that Excel sees this percentage as ".124", so
you have to Round to 3 decimals.