IF function - limit to the number of IFs?
 

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.

IF function - limit to the number of IFs?
 

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

Vaya con Dios,
Chuck, CABGx3


"jonrtait" wrote in message
...
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.

IF function - limit to the number of IFs?
 

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?

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3


"jonrtait" wrote in message
...
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.

IF function - limit to the number of IFs?
 

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


"jonrtait" wrote in message
...
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?

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3


"jonrtait" wrote in message
...
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.