Try playin with this formula:
B1: =VLOOKUP(A1,{0,1;1000,2;3000,3;5000,4;8000,5},2,1)

It uses a manually entered array, just like the vlookup function. Notice
that there are commas and semicolons in the array.

Type some value in A1 and the formula will return an approximate match from
the Vlookup.

Is that something you can use?

Ron



--
Regards,
Ron


"Antonio Mora" wrote:

There is a maximum set up for how many IF functions can be directly in a row
in a cell. My example:
=IF(AND(B450,B45<1000,1,IF(AND(B451000,B45<3000, 2,IF.... I would like to
continue this out to about 40, is this possible? or can I use some other
formula to make this work correctly?