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.