IF Function

Closed
Mitu - 12 Feb 2016 à 08:52
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 12 Feb 2016 à 11:48
Hello,

How many times we can use IF function in single formula?

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 Feb 2016 à 11:48
in versions of Excel 2007 and up, you can use up to 64 nested IFs. In older versions older than 2007, the threshold is 7 nested IFs. Any ways some thing is really wrong is such deep nested if is used (IMHO)