conditional formula

[Guest]

How can i use a conditional formula to return one of 3 values ie. if A1 is
less than x return 10 if it is between x and y return 20 and if it is greater
than y return 30

 

[Guest]

=(a1<x)*10 + (a1>=x)*(a1<=y)*20 + (a1>y)*30

 

[Guest]

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)

 

[JE McGimpsey]

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?

 

[Guest]

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]

Again, what is your exact formula?

It sounds like you're using "x" and "y" without defining them...

The Help topic I'd suggest looking at is "Correct a #NAME! Error"