Thread
:
IF function - limit to the number of IFs?
View Single Post
#
1
jonrtait
Posts: n/a
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.
Reply With Quote