Hi all, I have attached the Excel 2010 Workbook which I am referring to in this thread.
I am finding it difficult to enter a formula to calculate the discount. The 12% discount is only applicable to 10 OR MORE of the SAME products ordered (for example, if 10x 17" wheels only are ordered and 7x 18" wheels only are ordered, then the discount is only applicable for the 17" wheels. However if 10x 17" wheels only are ordered AND 10x 18" wheels only are ordered, then 12% discount is given EACH to BOTH of the products).
I want to know how to calculate the total discount (in cell F25). I have tried using the IF function and the LOOKUP function but both times it has become complicated and hard to get my head around.
Thanks in advance!!!!
Moderator's note: I have deleted the file, I just noticed it contains sensitive info (email and pp number)
Bookmarks