MrExcel Publishing
Your One Stop for Excel Tips & Solutions

calculation for discount

Posted by chock fay man on October 27, 2001 2:32 PM

I like to know that if some one order 2 windows or more a 5% discount applies. How do i make this work in MS excel 97. Can any one help. I have an idea is it If(cell:cell), or something different please help. please REPLY TO MY E-MAIL ADDRESS which is: AS SOON AS POSSIBLE. thank you.

Posted by Trevor Brooking on October 28, 2001 3:14 AM

If the price is in A1 and the quantity ordered is in B1, put this in C1 :-