Calculating tax on rebates

[Sabosis]

Hello-

I need to get a quick calulation to help me sovle a problem. I need to
issue a $50.00 credit, but need to take a tax rate into account. I
need to know the calculation if the $50.00 final credit amount is in
A1, and the tax rate is in A2, what calculation would be in cell A3
that would show the pretax price?

 

[JE McGimpsey]

This is pretty straightforward algebra:

f = p * (1 + r)

So

A3: = A1 / (1 + A2)

 

[Niek Otten]

If your tax rate is a a real Excel percentage (entered like15%):

=A1/(1+A2)