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)

"Gary's Student" wrote:

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


--
Gary's Student


"Matt" wrote:

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