• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How maximum nested if function allowed?

tiong999

Member
Hello All,

Im so glad to have all expert in this forum may contributing to solved my excel problem.

As the title, i want to know how maximum nested if function allowed...................is it 7?
If so, how can i made formula in my dependent data validation formula which need unlimited group for data validation?

Here i attach an excel example, so u can understand my question better.
Hopefully i can have a solution to my problem.


Thanks All,
Tiong999
 

Attachments

  • data validation.xlsx
    100.1 KB · Views: 7
Hello buddy,
I use excel 2007.

Yes, i want to build dependent validation list.
In my case, it will more than 7 group and go further unlimited dependent validation list.

Unfortunately, i have read those article but i dont find it usable for my case.


I alse read some new article, maybe can use for my case in ExcellsFun forum, but still not usable for dependent nested more than 7 nested if dependent validation data.


Hope u can direct me something new buddy. Cheers


Regards,
Tiong999
 
Last edited by a moderator:
Hi tiong999

@Luke M has given you a good link, you have to do some work and try to find a solution.
See if the idea is attached to you.
 

Attachments

  • tiong999-navic-42188.xlsx
    35.4 KB · Views: 5
Hi tiong999

@Luke M has given you a good link, you have to do some work and try to find a solution.
See if the idea is attached to you.
In Office 2003 or earlier, it 7. Newer versions can go up to 64 functions deep.

However, in your case, it looks like you're just wanting to build a dependent validation list.
https://www.contextures.com/xlDataVal02.html
Hello buddy,

Sorry for my late gratitude for pointing me to right direction.
Thanks anyway and i hope u both have a good day.


Regards,
Tiong999
 
Back
Top