Find automatic value that multiplying with a percentage will return me the value I want.

[ronald54457874]

I have a product that costs 48.41 and that's how much my supplier charges for the product.

I need to add 60% on top of this value, which will give me the result of 77.45.

But when I do 77.45 - 60%, instead of returning 48.41, it returns 30.98.

I need to make cell X calculate which value, adding 60%, will return automatic 48.41.

Thank you for your help.

 

[bebo021999]

But when I do 77.45 - 60%, instead of returning 48.41, it returns 30.98.

You are doing like this: 77.45-77.45*60% = 30.98
Should be:
77.45-48.41*60% = 48.41

 

[ronald54457874]

You are doing like this: 77.45-77.45*60% = 30.98
Should be:
77.45-48.41*60% = 48.41

Hello friend, but the result is not 48 but 46. If you do it the way you are doing it.

77.45-48.41 * 60% = 46.46
The problem in this case is lost 1.94, but if the values increase, they will become too high to be lost.

I need the macro to find the value I need, and it will add 60% and return me the value of 48.41. Is very difficult...

48.41 + 60% = 77.45 OK
77.45 - 60% = 46.46
? + 60% = 48.41

But it has to be automated in excel, currently I know it's the number 121 + 60% = 48.40.
I need the user to do nothing, the macro visualize looks for the value it needs to add to 60% and reach the value of 48.41 automatically. Thanks