Just divide your final price by your tax rate + 1. So, let's assume your
Final Price is in cell A1. Your formula would be:

=A1/1.07

HTH,
Elkar



" 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