I've built some pretty large expressions with If, .And. and .Or., and I've never had them fail. As long you're very careful about placing the ( and ) characters, I'd be very surprised to hear that Monarch didn't interpret the logic properly. Shocked, in fact.
As to the character length limit, as of v9 it's a whopping 32,786 (32K)characters, up from the 4K limit of v8. Large enough that nobody seriously wants to debug a formula of that size.
Thanks for such a quick answer!
Yes, 32,786 is big enough for ME!
I was really pretty sure that my parentheses were good. I even tried changing the one it was skipping to the beginning instead of the end. I got around it by using more Ifs.
I will look again next time this happens and, if I don't see the cause, save some examples to discuss here.
Somewhere at the back of my mind I recall that the IF() function supports a maximum of 36 nested expressions.
However I think if one uses the patented Osdale-Popa method of conjoining multiple IF() statements (using the + sign) then you are only limited by the max number of characters available which, as Kruncher has pointed out, became quite a big number in Version 9.
Can anyone confirm this and save me a trawl back through the archives?
Another possibility is that part of the formula is not evaluating how you think it should. For instance null (and you think it's zero), a string (and you think it's a number) or some other mis-match.
You can check using the "test" tab on the variable, or by breaking down the calculation step-by-step, or try posting the calculation on this site.
Even on version 8 it was very difficult to "blow" the limit on calculations.
Hmm. The search was not so difficult. I don't remember hearing that the limit has changed but if anyone knows different please advise.
Some of the character in the code section have lost their interpretation in conversion form the old forum but I think the gist of the information is still clear.