| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove the tax from a total to get the pre tax value ?
TaxedPrice = OriginalPrice*(1.175)
So: OriginalPrice = TaxedPrice / 1.175 With TaxedPrice in A1 use =A1/1.175 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "David" wrote in message ... If I try to remove 17.5% (UK Value Added Tax) from a total it's also calculating the additional 17.5% on the original value as well. How can I get to the true original value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I search for a total using nonadjacent cells | Excel Worksheet Functions | |||
| Percent of total in Pivot tables | Excel Worksheet Functions | |||
| sum of total hours not correct | Setting up and Configuration of Excel | |||
| show in a excel graphic a total percentage for 5 diff data fiels | Charts and Charting in Excel | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
