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

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History