| 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. |
| 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 | |||
Threaded Mode
