Maximum formula length

Unsure if this is actually in reality an Excel issue, but I just spent a couple of days troubleshooting a report that contained a formula that was simply too long. It appears there is a 255 character limit. Excel (2007) does not state it has a problem with this, but Jet comes up with a message that you cannot mix nested formulas and names or something (only after three days did i see it may be that it was just too long).

Now, which do you feel is more legible?

=NL("Rijen";"Vendor Ledger Entry";"Vendor No.";"Limiet=";"20";"+=NL(""Som"";""Vendor Ledger Entry"";""Amount"";""Vendor No."";NF(;""Vendor No."");""Document Type"";""Invoice|Credit Memo"";""Open"";""<>0"";""Due Date"";"""&$B$43&""")";"*";"Document Type";"Invoice|Credit Memo";"Open";"<>0";"Due Date";$B$43)



The latter is btw also the longest possible as adding an L/M52 pair (i.e. COMPANY=) makes it go over 255…

I vote for the first option, which would require a stretch of the maximum formula length to more than 255 chars. Who else feels this to be desirable?


Please sign in to leave a comment.