Below is content of cells A1:B3:
A1:A2 show content of Cells B1:B2
B3 is simply the Value 8.
A B
1 =B3/1.07 7.48
2 =B1*0.07 0.52
8.00



Hope that helps..

wrote in message
oups.com...
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