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

1 answer

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)