Getting sum total from percentage instead of percentage amount

Hey there,

So I have a formula "=IF(E2>=$A$13,E2*$A$14,0)" (A13 is the amount to decide whether a discount is allowed, which is anything over $5,000 and A14 is the percentage amount of 10%) as you can see in this screenshot: http://puu.sh/3Zh7U/6481608141.png

Now, when I enter the above formula for the first column, I should be getting $5,040 for the total, but instead I get the discount amount of $560, so how can I get it to change to the total discounted amount instead of the percentage amount?

Hi,

Simply change it to either:

=IF(E2>=$A$13,E2-(E2*$A$14),0)

or

=IF(E2>=$A$13,(1-$A$14)*E2,0)

Regards

You're welcome.