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: chock_2000uk@yahoo.com. 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 :-

=IF(B1>1,A1*0.95*B1,A1)