Hi John

From your example GST looks like it is set to 10%. If it is the same
rate for Postage as for goods, then amend the formula in the cell
holding the GST value.
At the moment it will be saying something like =D20*10%
Change it to =(D20+D21)*10% where D20 represents the cell holding sub
total, and D21 holds the postage cost.

--
Regards

Roger Govier


"Johncobb45"
wrote in message
...

I use Microsoft Excel for writing invoices.
In the standard invoice, Tax (GST) on Shipping and Handling is not
calculated and added to the total.
I want someone to fix this, so Goods and Services Tax (GST) will be
calculated and added on Postage and Handling in the total amount.
At present, Shipping and Handling is set fixed. I want to be able to
enter diferent amount each time without going to Customize Page and
setting it there.
Thank you in advance for your help.
Best regards,
John

PS: Below I have included the xls file. It is a bit
messy.
Tax Invoice No. 2089
ABN:

Name: Date 11/01/2006
Address: Order No.
City: Karuah NSW 2324 Rep
Phone: FOB

Qty Description Unit Price TOTAL

6 Anti Snoring Blend (Aromatherapy 100% essential
oils) $18.00 $108.00

SubTotal $108.00
Shipping & Handling $7.50
Taxes GST $10.80
TOTAL $126.30


--
Johncobb45
------------------------------------------------------------------------
Johncobb45's Profile:
http://www.excelforum.com/member.php...o&userid=16582
View this thread:
http://www.excelforum.com/showthread...hreadid=500046