Nested If Limit and alternative for Nested If

[Anonymous]

Hi All,

I've to create a report in which around 124 Nested If condition is being used.What is the limit of If's in nested if and is there alternative to it.

I am attaching the sample report structure for your help.I am not able to exceed 96 if within the nested if.

Thanks

Abhinav Pandey

[MK_QSL]

Nested if Limit is 99 if.....

You can use Match or WildMatch instead...

[tresB]

=Pick(Match(....

Replace Multiple If Statements