|
Percentage function formula
Hello, I have inserted my sheet to give you an idea of what I am trying to do. My boss wants the freight/fuel plus tax(which is the totalH/C) to be costed out to each job based on the % that the individual job costs are in relation to the whole invoice. I have instructed the sheet to take the total job cost and find what % it is to the 318.44 and then I told it to take that % x the 37.61 (H/C) to add that cost for a total cost, but the total at the bottom for H/C do not equal the H/C which then throws off the cost. How do I get the %'s accurate so that my H/C is correct? I have a difference of $4.45. Thank you Gracious :) ************************************************** ************ Invoice Total $318.44 Freight $30.00 Fuel $4.50 9% Tax $3.11 Total H/C $37.61 % of Name Amount 9% Tax Total invoice H/C Total Cost Job $157.44 $14.17 $171.61 53.89% $20.27 $191.88 Job $33.03 $2.97 $36.00 11.31% $4.25 $40.25 Job $57.18 $5.15 $62.33 19.57% $7.36 $69.69 Job $9.99 $0.90 $10.89 3.42% $1.29 $12.18 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $257.64 $23.19 $280.83 $33.16 $313.99 edited: guess you can't copy and paste....how can I get this on here so that you will be able to see it correctly?????? -- gracious ------------------------------------------------------------------------ gracious's Profile: http://www.excelforum.com/member.php...o&userid=23166 View this thread: http://www.excelforum.com/showthread...hreadid=382922 |
Gracious...
Your percentages do not add up to 100 You need to divide each individual job cost into the sum of the job costs not into the invoice total.i.e. 171.61 into 280.83 to get 61.1085% etc. -- Greetings from New Zealand Bill K "gracious" wrote in message ... Hello, I have inserted my sheet to give you an idea of what I am trying to do. My boss wants the freight/fuel plus tax(which is the totalH/C) to be costed out to each job based on the % that the individual job costs are in relation to the whole invoice. I have instructed the sheet to take the total job cost and find what % it is to the 318.44 and then I told it to take that % x the 37.61 (H/C) to add that cost for a total cost, but the total at the bottom for H/C do not equal the H/C which then throws off the cost. How do I get the %'s accurate so that my H/C is correct? I have a difference of $4.45. Thank you Gracious :) ************************************************** ************ Invoice Total $318.44 Freight $30.00 Fuel $4.50 9% Tax $3.11 Total H/C $37.61 % of Name Amount 9% Tax Total invoice H/C Total Cost Job $157.44 $14.17 $171.61 53.89% $20.27 $191.88 Job $33.03 $2.97 $36.00 11.31% $4.25 $40.25 Job $57.18 $5.15 $62.33 19.57% $7.36 $69.69 Job $9.99 $0.90 $10.89 3.42% $1.29 $12.18 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $257.64 $23.19 $280.83 $33.16 $313.99 edited: guess you can't copy and paste....how can I get this on here so that you will be able to see it correctly?????? -- gracious ------------------------------------------------------------------------ gracious's Profile: http://www.excelforum.com/member.php...o&userid=23166 View this thread: http://www.excelforum.com/showthread...hreadid=382922 |
Your problem may be a rounding problem. spread sheets don't attach to what I
can read. "gracious" wrote: Hello, I have inserted my sheet to give you an idea of what I am trying to do. My boss wants the freight/fuel plus tax(which is the totalH/C) to be costed out to each job based on the % that the individual job costs are in relation to the whole invoice. I have instructed the sheet to take the total job cost and find what % it is to the 318.44 and then I told it to take that % x the 37.61 (H/C) to add that cost for a total cost, but the total at the bottom for H/C do not equal the H/C which then throws off the cost. How do I get the %'s accurate so that my H/C is correct? I have a difference of $4.45. Thank you Gracious :) ************************************************** ************ Invoice Total $318.44 Freight $30.00 Fuel $4.50 9% Tax $3.11 Total H/C $37.61 % of Name Amount 9% Tax Total invoice H/C Total Cost Job $157.44 $14.17 $171.61 53.89% $20.27 $191.88 Job $33.03 $2.97 $36.00 11.31% $4.25 $40.25 Job $57.18 $5.15 $62.33 19.57% $7.36 $69.69 Job $9.99 $0.90 $10.89 3.42% $1.29 $12.18 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 $0.00 $257.64 $23.19 $280.83 $33.16 $313.99 edited: guess you can't copy and paste....how can I get this on here so that you will be able to see it correctly?????? -- gracious ------------------------------------------------------------------------ gracious's Profile: http://www.excelforum.com/member.php...o&userid=23166 View this thread: http://www.excelforum.com/showthread...hreadid=382922 |
Gracious... Your percentages do not add up to 100 You need to divide each individual job cost into the sum of the job costs not into the invoice total.i.e. 171.61 into 280.83 to get 61.1085% etc. -- Greetings from New Zealand Bill K Thank you so very much! I guess I had looked at it too long and got frustrated :eek: and didn't realize that I was adding in the H/C to calculate the %....whew...what a relief thank you for setting me straight and all the way from New Zealand!!! :) TY Bill K HUGS HUGS HUGS ;) -- gracious ------------------------------------------------------------------------ gracious's Profile: http://www.excelforum.com/member.php...o&userid=23166 View this thread: http://www.excelforum.com/showthread...hreadid=382922 |
Thank you for the feedback.
It made my day. Bill K "gracious" wrote in message ... Gracious... Your percentages do not add up to 100 You need to divide each individual job cost into the sum of the job costs not into the invoice total.i.e. 171.61 into 280.83 to get 61.1085% etc. -- Greetings from New Zealand Bill K Thank you so very much! I guess I had looked at it too long and got frustrated :eek: and didn't realize that I was adding in the H/C to calculate the %....whew...what a relief thank you for setting me straight and all the way from New Zealand!!! :) TY Bill K HUGS HUGS HUGS ;) -- gracious ------------------------------------------------------------------------ gracious's Profile: http://www.excelforum.com/member.php...o&userid=23166 View this thread: http://www.excelforum.com/showthread...hreadid=382922 |
| All times are GMT +1. The time now is 04:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com