If price is in A1 and discount percentage in B1 (either in the form of 10% or
like 0.10) use this in C1
=A1*(1-B1) to get the discounted price...

or use
= 150 * (1 - 20%)

or use
= 150 * (1 - 0.20)

"anna" wrote:

I need to work out discount rate from price
Example
50 divided by 1.1 gives me the correct result 45
But if I divide 150 by 1.2 instead of giving me 120 the result is 125
I need one formulae I dont want work out first the discount rate and then
price - discount