Ask yourself a few questions:
What data do you need to use to calculate the discount?
Where are those data values stored?
What does Excel help say about absolute reference?
If you don't know the syntax of the IF function, Excel will tell you that
too.
--
David Biddulph

"owls_amy" wrote in message
...
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.