Microsoft Excel trying to build an invoice

[V.E.]

I am trying to build an invoice using Microsoft excel. I need it to use a
different rate for different quantities. (ex. for qty less than 5, I need
to use one rate, for qty 5-9, I need to use another rate, and for qty 10 and
over I need to use a different rate.) Any advice on a formula for this?
Thanks!!!

 

[RobertVA]

I am trying to build an invoice using Microsoft excel. I need it to use a
different rate for different quantities. (ex. for qty less than 5, I need
to use one rate, for qty 5-9, I need to use another rate, and for qty 10 and
over I need to use a different rate.) Any advice on a formula for this?
Thanks!!!

Use an "IF(" function as the fail value inside another "IF(" function.

the logic is:

If quantity is less than 5
charge full price
but if it isn't (less than 5)
If quantity is less than 10
give the smaller discount
but if it still isn't (less than 10)
give the larger discount
end (of alternates for quantity is less than 10)
end (of alternates for quantity is < 5, in spreadsheets this is where
you put the closing parentheses. Two end of alternatives means you NEED
to type two parentheses)

Something like =e5*IF(e5<5,d5,IF(e5<10,d5*0.95,d5*0.90))

where quantities are in column e and undiscounted price is in column d

 

[JoAnn Paules]

Why don't you post your question in one of the Excel newsgroups? I know
you'll need a couple of IFs but I'd have to look up how to do this.