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