Asked by Tiler

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

Answers

Answered by economyst
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)
There are no AI answers yet. The ability to request AI answers is coming soon!

Related Questions