Problem calculating Using a Percentage

[BrownsFan]

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?

 

[John C]

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.

 

[Niek Otten]

<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


|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?

 

[BrownsFan]

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





- Show quoted text -

John,

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

 

[Spiky]

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.