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
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)
@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!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.