Excel reverse calculation

Question

Can some help me to create reverse calculator,

simple calculation Price + tax = total

Example ( 100 +11% = 111) --- {I am able to do this}

WHAT I AM LOOKING FOR IS

TOTAL - TAX = PRICE

Example(111 - 11% = ___? {this value should be 100})

Answer 1

One general way:

Answer 2

First, price + tax = total is not 100 + 11% = 111. Note that 11% = 0.11 .

It is price * (1+tax) = total

So total / (1+tax) = price