IF Function

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

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

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 12, 2016 at 11:48 AM
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)
0