Ok I have an order sheet for clothing, if total order quantities reach
certain levels i get a bulk discount. there are 3 levels of discount and so i
wish to return one of 3 values. A1 contains the total no of garments 1-2 are
£20, 3-10 are £15 and 10+are £10 hence i wish a formula which says: if A1<=2
return a value of 20 if 3<=A1<=9 return a value of 15 and if A1=10 return a
value of 10
the formula suggested returns #NAME? if there is a help function associated
with this then i am fine to work through it myself but i can't find one,
largely because i don't know what to search under
thanks again
"JE McGimpsey" wrote:

It's hard to make a suggestion unless you say what "does not seem to
work" means...

Do you get an error? An incorrect value? A crash?

What is your exact formula after you substitute your "x" and "y"
variables for numbers or cell references?

In article ,
"Matt" wrote:

This does not seem to work, i am probably just doing somthing stupid. what
should i look at on the help to work through it
(thanks for the help though)