Enter the following data in a section of your spreadsheet (say J2:K7)

0    70%
1.0001    60%
1.4001    50%
2.0001    30%
2.5001    30%
3.0001    30%

put your number in cell a1
put this formula in cell b1 =VLOOKUP(A1,$J$2:$K$7,2,1)

The way it works, is the formula looks down column J and compares the
number in A1 against the first number if finds.  It keeps going down
the column until it gets a number *larger *than the one in cell A1.  It
the goes back up 1 row and takes the number from column K as the result.

Because you want the range to be <= to 1.4 (for example), you need a
number slightly bigger than 1.4 ie 1.4001.  As described above, when
the search finds 1.4001, it then goes back and takes 60% as the value.
If there was a perfect match for 1.4, it would take the value 50% (not
what you want).  You therefore need to set the 1.4001 etc to a level of
accuracy (ie decimal points) lower than the number in cell A1.

Matt

=IF(AND(0<A1,A1<=1),0.7,IF(AND(1<A1,A1<=1.4),0.6,IF(AND(1.4<A1,A1<=2),0.5,IF(AND(2<A1,A1<=2.5),0.4,IF(AND(2.5<A1,A1<=3),0.3,IF(A1>3,0.3))))))

AND(0<A1,A1<=1) * 0.7 + AND(1<A1,A1<=1.4) * 0.6 +
AND(1.4<A1,A1<=2) * 0.5 + AND(A1>2) * 0.3

Bruno

Another alternative..........

=LOOKUP(A1,{0,1.1,1.5,2.1},{"70%","60%","50%","30%"})

Vaya con Dios,
Chuck, CABGx3