| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sales tax VAT
I need aformula that will deduct 17.5% from a gross figure to give me how
much sales tax has been paid and therefore the net amount. Muliplying by 0.1489 works great on 117.50 but goes astray on any figure above that. any help much apreciated, don't want to give the TAXMAN any more than he is due. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sales tax VAT
Try this
=A1/117.5*100 Mike "Jacko99" wrote: I need aformula that will deduct 17.5% from a gross figure to give me how much sales tax has been paid and therefore the net amount. Muliplying by 0.1489 works great on 117.50 but goes astray on any figure above that. any help much apreciated, don't want to give the TAXMAN any more than he is due. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sales tax VAT
I may have read you post incorrectly. To calculate the tax part of a fross
amount try this =A1-(A1/117.5*100) Mike "Jacko99" wrote: I need aformula that will deduct 17.5% from a gross figure to give me how much sales tax has been paid and therefore the net amount. Muliplying by 0.1489 works great on 117.50 but goes astray on any figure above that. any help much apreciated, don't want to give the TAXMAN any more than he is due. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sales tax VAT
Did you mean, for instance:
A1 has a value of 1500 and you want to calculate 17.5% tax on 1500. If yes, then formula will be: A1 B1 C1 Sales Sales Tax Net Amount 1500 =A1/100*17.5 =A1-B1 1500 262.5 1237.5 Hope this is what you wanted, let us know! "Jacko99" wrote: I need aformula that will deduct 17.5% from a gross figure to give me how much sales tax has been paid and therefore the net amount. Muliplying by 0.1489 works great on 117.50 but goes astray on any figure above that. any help much apreciated, don't want to give the TAXMAN any more than he is due. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sales tax VAT
My tax man would love you, you just paid 39.10 too much tax
1235.5 * 1.175 = ? Mike "RajKohli" wrote: Did you mean, for instance: A1 has a value of 1500 and you want to calculate 17.5% tax on 1500. If yes, then formula will be: A1 B1 C1 Sales Sales Tax Net Amount 1500 =A1/100*17.5 =A1-B1 1500 262.5 1237.5 Hope this is what you wanted, let us know! "Jacko99" wrote: I need aformula that will deduct 17.5% from a gross figure to give me how much sales tax has been paid and therefore the net amount. Muliplying by 0.1489 works great on 117.50 but goes astray on any figure above that. any help much apreciated, don't want to give the TAXMAN any more than he is due. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sales tax VAT
"Mike H" wrote: My tax man would love you, you just paid 39.10 too much tax 1235.5 * 1.175 = ? Mike "RajKohli" wrote: Did you mean, for instance: A1 has a value of 1500 and you want to calculate 17.5% tax on 1500. If yes, then formula will be: A1 B1 C1 Sales Sales Tax Net Amount 1500 =A1/100*17.5 =A1-B1 1500 262.5 1237.5 Hope this is what you wanted, let us know! "Jacko99" wrote: I need aformula that will deduct 17.5% from a gross figure to give me how much sales tax has been paid and therefore the net amount. Muliplying by 0.1489 works great on 117.50 but goes astray on any figure above that. any help much apreciated, don't want to give the TAXMAN any more than he is due. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating sales commission that changes based on a sales volume | Excel Worksheet Functions | |||
| Sales Invoicing linked to Sales ledger(Accounts Receivable) | Excel Discussion (Misc queries) | |||
| Add Sales Goals to Sales Report in Pivot Table | Excel Discussion (Misc queries) | |||
| sales needed to cover costs that increase as sales do | Excel Worksheet Functions | |||
Linear Mode
