Ty Sandy M.
No . I want the fuel price that is entered in one cell to determine the
percentage ie 15% and that % will be added to the total cost per load or
subtotal that is in another cell directly beneath it.
In other words say the base price for a load is 9.00 per ton. we formulate
that x the number of tons in the load ,ie 26 tons. Then we gat a subtotal
and formulate a fuel surcharge determined by the cost of fuel, (which
changes) to get a final cost for the load.
Is this at all clear? the basenumber of tons, price per ton, are added to
get the subtotal. Then we add the %surcharge and get the final cost per load
for each load.
All the calculations are done aumatically when I click on the "modify
Invoice " key.
each load is on one line accross and the total of all loads adds up at the
bottoms of the colums on the invoicer. The "virtual office is in Groove',
but only my son has administration privledges and he is out of the country,
so i need to make one for myself.
Can I state it any better for you? Sorry if I am not good at this.

"Sandy Mann" wrote:

2.870 - 2.935 13% added to fuel charge and calculated automatically when
the fuel charge is entered and I click "modify invoice details"

Does this mean that you want the fuel price altered in the same cell, ie
with a Macro so that $2.870 becomes $3.243?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Millie Dunham" wrote in message
...
Help, I need a formula to increase the surcharge on fuel for my company
and I
know nothing about this task. for example :
FUEL SURCHARGE INFO.
2.870 - 2.935 13% added to fuel charge and calculated automatically when
the fuel charge is entered and I click "modify invoice details"
2.935 - 3.037 14%
.
.
3.870 - 3.953 25%
I need to contunue to about $5.249.
Can anyone help me?