Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, can somebody tell me how to set up a formula that will give me the
BEFORE TAX PRICE given SALES TAX RATE and FINAL PRICE? For example, I sell 3 apples to Bob for $8. Assuming sales tax is 7%, I need a formula that will show me what the before tax price is. I know that the equation on paper would be something like: BEFORE TAX PRICE + (BEFORE TAX PRICE X 7%) = $8 But how do I set something like this up in Excel so that I can simply input the FINAL PRICE and have the BEFORE TAX PRICE outputed? Thanks! Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel should calculate exponentials properly (right to left) | Excel Worksheet Functions | |||
How do I calculate a MTD total - yesterdays sales in Excel? | Excel Worksheet Functions | |||
MSNStockQuote Function Parameters | Excel Worksheet Functions | |||
Creating an interactive Global Map in Excel | Excel Discussion (Misc queries) | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel |