How maximum nested if function allowed?

[tiong999]

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

 

[Luke M]

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

 

[tiong999]

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

 

[navic]

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.

 

[tiong999]

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