Assuming that A1 contains your final price, try...

=A1/1.07

or

=A1/(1+B1)

....where B1 contains your sales tax rate, such as 7%.

Hope this helps!

In article .com,
" wrote:

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