Tax reverse calculation formula.

I have a product used to sell for 118 which includes value of the product is 100 + 9% of CGST tax + 9% of SGST tax which equals 100+9+9=118.

Now I want to calculate the tax from the total cost. for example, total cost is 118, i need a help for the formula to work back 100+9+9=118.

I have tried, but i am getting wrong answer.

Originally Posted by Bernie Deitrick

Your total cost (TC) is calculated from cost (C) by the formula

TC=C*118%

So

C = TC/118%

or, for an example formula

=B2/1.18

Thanks very much. works fine

Thanks very much, works fine.