Excel IF statement to give a discount

[Chris559]

I want to give a 5% discount to orders (values) over £50. I have put in the following formula:

=IF(G48<50,G48/100*95,G48/100*100) which doesn't work. It returns whatever the value is in G48 no matter if it is greater than 50 or not.

I also tried =IF(G48<50,G48/100*95,G48) to no avail.

What am I doing wrong?

 

[HowardHammerman]

I believe you want:
IF(G48>50,G48-(G48*.95),G48)
Note the use of > and the decimal point
This is the final value after the 5% discount.
If you want a separate column just to show the discount:
IF(G48>50,G48*.05,0)

No need to divide by 100.

Cheers!

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Chris559]

Many thanks - will teach me to be more observant!