Conditional statements using IF

Hello,
OK, I am trying to learn conditional statements using the IF function. So far so good, but, I now want to complicate matters a bit and I am having trouble.
I have attached a 2004 excel document that has a conditional statement that says, if an amount is over $400.00 you get a 10% discount, else, the cell says no discount. That is working fine. I also have a absolute cell ready to do the math for the 10% amount. There is also a column that shows the discount amount and column that shows the amount after the discount has been applied. Since I have been just doing one calculation and auto-filling, my problem is, how do I get the record that doesn't get a discount (no discount) not to apply the 10%?

Any ideas how to do this based on my example, here.
thanks!
barbara

You could use this in columnn-F copied down

=IF(D2>400,D2-(D2*0.1),D2)

If the total is over $400, a 1o% discount will be applied,otherwise it will show the total and not apply a discount.

Glad to have helped.

Please be sure to mark your thread as solve. Click on thread tools at the top of your post and choose Go Advanced, then choose Solved.