=(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