help with a if function question
 

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.

help with a if function question
 

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.

help with a if function question
 

hi david
I am still not sure what to do. Can u show me a example of what u mean?
thanks a
amy
"David Biddulph" wrote:

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.

help with a if function question
 

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?
--
David Biddulph

"owls_amy" wrote in message
...

hi david
I am still not sure what to do. Can u show me a example of what u mean?
thanks a
amy
"David Biddulph" wrote:

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.