Price percentage formula

Hi Everyone,

Any help would be appreciated here on this, I am not sure this is even possible, I've been asked to achieve the following:


Example :


We have a Cost Price £8.30
A Sales Target Price of £12.50
We also have a List Price of £16.25 The List Price is 30% on top of the Target Price.


The brief I have been given is that there "apparently" is a formula which returns the List Price back to the same value of Target Price.




I need the formula to be the same, so it can be applied to our system for all our products. I just don't see how this can be done.

Any suggestions are welcome.

Thanks for your help.

List Price divided by 1.3 = Target Price

Anwar said:

List Price divided by 1.3 = Target Price

Click to expand...

Your a star. That's exactly what I needed.

For some reason, I just could not see that. It seems so obvious now..

I really appreciate your help.

I was getting a different result, I kept achieving £16.25 / 30% was returning 4.875, then taking that off the £16.25 which returned £11.375

My brain just wasn't working in the right way obviously.

Thanks !!!!!!