Antonio,

Another option is to use binary switching formulas. They will work for
numbers. However, text entries will not work.

http://www.pdbook.com/index.php/exce...itch_formulas/

--
Regards,
John Mansfield
http://www.pdbook.com


"Antonio Mora" wrote:

That seems to work just fine, thank you very much. I havent gone all the way
out to the numbers I need yet but its working past 7 :). Hopefully it will
continue. Thanks lots Ron.

"Ron Coderre" wrote:

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?