How do I write this formula: Use the IF function with an absolute reference to the discount value listed in cell I3. The discount only applies to orders with a quantity of two or more; otherwise, the discount is zero.

With your quantity in A1 and your discount in A2, try this: =IF(A1>1,$A$2,0)

(Assumes there is no such thing as a quantity between 1 and 2)

Whoops, missed the I3 reference... =IF(A1>1,$I$3,0)

Thank you so much for your help. That worked out fine. Thanks again.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History