IF function - limit to the number of IFs?

J

jonrtait

Is there a limit to the number of IF statements you can have in one function?

i.e. =IF(a1<a10,a10,(IF(a1<a11,a11,(IF(a1<a12,12,(IF(.................. and
so on.

I seem to get to 8 IFs and then get an error.
 
C

CLR

That's it..........take a look at the VLOOKUP function.........

Vaya con Dios,
Chuck, CABGx3
 
J

jonrtait

Thought so....

Only problem with the LOOKUP functions is that if an exact match is not
found, the next largest value that is less than lookup_value is returned....
but I need the next largest value that is GREATER than the lookup_value....

Any thoughts?
 
C

CLR

If your data increments are equally spaced, like 100, 200, 300,
etc.........maybe something like.....

=IF(ISNA((YourVlookupFormula,FALSE), (YourVLookupFormula+OneIncrement,True),
(YourVlookupFormula,FALSE))

Vaya con Dios,
Chuck, CABGx3
 
Top