IF Function
Closed
Mitu
-
Feb 12, 2016 at 08:52 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- IF Function
- Functionality of wifi - Guide
- Which function can be used to directly bring automated data from one worksheet to another worksheet - Guide
- Functions of spreadsheet - Articles
- Function key stuck on - Guide
- Acer function keys not working - Guide
1 reply
rizvisa1
Feb 12, 2016 at 11:48 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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)