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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 12 Feb 2016 à 11:48
Related:
- IF Function
- Hard drive function - Guide
- Lan card function - Guide
- Iserror function in excel with vlookup - Guide
- Vba find function - Guide
- Insert key function - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
12 Feb 2016 à 11:48
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)