help with a if function question

O

owls_amy

Hi guys

I have this question and I don't know how to answer the question so here is
the question that I have from my homework I am using excel 2007

plz someone help me I am so confused.

Calculate the appropriate discount for each order. Use the if function with
absolatreference to the discount value listed in cell i3. The discount only
applies to orders with a quantity of 2 or more. otherwise , the discount is
zero. place the calculated value in the discount column.
 
D

David Biddulph

You need to understand the question before you can find how to get the
answer from Excel.
If you were doing the calculation by hand, what steps would you go through?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top