software

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:Date11/01/2006
Address:Order No.
City:Karuah NSW2324Rep
Phone:FOB

QtyDescriptionUnit PriceTOTAL

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

SubTotal $108.00
Shipping amp; Handling $7.50
Taxes GST $10.80
TOTAL $126.30--
Johncobb45
------------------------------------------------------------------------
Johncobb45's Profile: www.excelforum.com/member.php...oamp;userid=16582
View this thread: www.excelforum.com/showthread...hreadid=500046Hi 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 Govierquot;Johncobb45quot; gt;
wrote in message
...
gt;
gt; I use Microsoft Excel for writing invoices.
gt; In the standard invoice, Tax (GST) on Shipping and Handling is not
gt; calculated and added to the total.
gt; I want someone to fix this, so Goods and Services Tax (GST) will be
gt; calculated and added on Postage and Handling in the total amount.
gt; At present, Shipping and Handling is set fixed. I want to be able to
gt; enter diferent amount each time without going to Customize Page and
gt; setting it there.
gt; Thank you in advance for your help.
gt; Best regards,
gt; John
gt;
gt; PS: Below I have included the xls file. It is a bit
gt; messy.
gt; Tax Invoice No. 2089
gt; ABN:
gt;
gt; Name: Date 11/01/2006
gt; Address: Order No.
gt; City: Karuah NSW 2324 Rep
gt; Phone: FOB
gt;
gt; Qty Description Unit Price TOTAL
gt;
gt; 6 Anti Snoring Blend (Aromatherapy 100% essential
gt; oils) $18.00 $108.00
gt;
gt; SubTotal $108.00
gt; Shipping amp; Handling $7.50
gt; Taxes GST $10.80
gt; TOTAL $126.30
gt;
gt;
gt; --
gt; Johncobb45
gt; ------------------------------------------------------------------------
gt; Johncobb45's Profile:
gt; www.excelforum.com/member.php...oamp;userid=16582
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=500046
gt;

Thanks for your help Roger. Well done.

I still cant get one more thing.
When I want to insert an amount in Shipping and Handling field the
system shows me the following message: quot;SHIPPING CHARGE - To add a
shipping charge, click the 'Customize' button above and change the
information in the 'Specify Default Invoice Information Here..' boxquot;.
When I go to CUSTOMIZE YOUR INVOICE page there is nothing in the
quot;Shipping Chargequot; field.
I don't see how can I customize it. There are no options.
Can you help me with this one please?
I want this field/cell to be empty not preset with some amount because
each time i post an item the postage is diferent.
Thank you in advance for your help.
Regards,
John K.--
Johncobb45
------------------------------------------------------------------------
Johncobb45's Profile: www.excelforum.com/member.php...oamp;userid=16582
View this thread: www.excelforum.com/showthread...hreadid=500046Hi John

Surely you must be clicking in the wrong field. It must be a numeric
field if it is being used as part of the overall total, or it has to be
a formula, pulling a value from another cell.
Try the field to the right of the one you have been attempting to alter.
If you are still having problems, mail me a copy of the file direct( not
via the NG) and I will take a look.

Remove NOSPAM from my address to send direct
roger@ NOSPAM technology4u.co.uk

--
Regards

Roger Govierquot;Johncobb45quot; gt;
wrote in message
...
gt;
gt; Thanks for your help Roger. Well done.
gt;
gt; I still cant get one more thing.
gt; When I want to insert an amount in Shipping and Handling field the
gt; system shows me the following message: quot;SHIPPING CHARGE - To add a
gt; shipping charge, click the 'Customize' button above and change the
gt; information in the 'Specify Default Invoice Information Here..' boxquot;.
gt; When I go to CUSTOMIZE YOUR INVOICE page there is nothing in the
gt; quot;Shipping Chargequot; field.
gt; I don't see how can I customize it. There are no options.
gt; Can you help me with this one please?
gt; I want this field/cell to be empty not preset with some amount because
gt; each time i post an item the postage is diferent.
gt; Thank you in advance for your help.
gt; Regards,
gt; John K.
gt;
gt;
gt; --
gt; Johncobb45
gt; ------------------------------------------------------------------------
gt; Johncobb45's Profile:
gt; www.excelforum.com/member.php...oamp;userid=16582
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=500046
gt;