Switch Function Limits number of test cases?

[Dana]

Is there a limit to the number of cases one can have in a Switch function
statement when using a formula to customize a field? I can not get more than
14, without a syntax error.

 

[Dale Howard [MVP]]

Dana --

I can confirm you findings. It appears the limit is 14 expressions using
the Switch function. Hope this helps.

 

[Jack Dahlgren]

There is also a character limit to formulas. Not sure if that is what you
are running up against.
If you need more, consider using VBA macros.

-Jack

 

[Dana]

Thanks for the confirm. I since thought of a work-around, by using an IFF
statement but that didn't work either. Iff (case 15 is true, answer 15,
Switch ( among 14 other cases)) Not sure why this wouldn't work.