Question
How am i to Calculate the appropriate discount using the IF function with an absolute reference to the value listed in cell I1( which is 10%) for any order with a quantity of two or more; otherwise the discount is zero. Place the calculated discount value in the discount column.
Thank you
This is within Case Grader
Thank you
This is within Case Grader
Answers
I think I see your problem. The IF function in excel is:
@IF(logical test, value if true, value if false)
So let column A be price, B be quantity, column C be receipts after discount. So for any sale (row i), put in the C columns cell row i:
@IF (Bi >= 2, Ai*Bi*(1-$I$1), Ai*Bi)
@IF(logical test, value if true, value if false)
So let column A be price, B be quantity, column C be receipts after discount. So for any sale (row i), put in the C columns cell row i:
@IF (Bi >= 2, Ai*Bi*(1-$I$1), Ai*Bi)
Related Questions
A store offers a discount of 30% on all reference books.
If a dictionary costs 12$ before the disco...
a story is offering a 30% discount in all items. Also, employees get a 10% employee discount. Write...
A store is offering a 15% discount on all items. Also, employees get a 20% employee discount.
Write...