If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|