If Function

March 3, 2009 at 11:08:00
Specs: Windows Vista
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.

See More: If Function

Report •

March 3, 2009 at 12:20:05
With your quantity in A1 and your discount in A2, try this:


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

Report •

March 3, 2009 at 12:21:28
Whoops, missed the I3 reference...


Report •

March 4, 2009 at 11:01:20
Thank you so much for your help. That worked out fine. Thanks again.

Report •

Related Solutions

Ask Question