Well I have this formula: IF(AND(A1>=20,A1<=40),1000,2000) that generates true value 1000 and false value 2000 in B1 if A1 is between and egual 20<=40. What I want to do is create a formula that can handle more values. For example using the same A1 and B1 I want a series of ranges apply to different true and false values.

IF A1 between 20<=40 B1=1000
IF A1 between 41<=60 B1=2000
IF A1 between 61<=80 B1=3000 and so on........

Can somebody help? Thank you.