View Single Post
  #1   Report Post  
jonrtait
 
Posts: n/a
Default 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.