Adding a % to a final number

Question

We have products that we need to add a % to the final number, for agent commissions.

If we have a $100 product and want to add 20% commissions, the first thought is to add 20%.

In the end, after agent compensation is paid out, we need to have $100 left.

If you add 20%, you get $120.

If you pay the agent 20% that would not be $20, it would be $24, leaving only $96.

If I increase the product to $124 then the agent commission is $24.8 which leaves only $99.20.

Now I could keep doing this until I got close but I need a quick and easy formula.

I need a formula that tells me the price needed so that once the agent gets his 20% commission the final amount left is still $100.

Answer 1

Hi,

In cell C2, enter

=A2/(1-B2)

A2 has 100 and B2 has 20%

Hope this helps.

Answer 2

You may try

=A2*1.25