Forum Discussion
Excel function not working
Riny is being kind when he describes that as "an incredible function"
In fact it's a casebook example of a DYSfunctional Function. I think any good reference manual on Excel will warn that just because it's possible to write a formula that is, whatever, a 1,000 characters long, doesn't mean it's a good idea. It might be fun to have written such a function and to have had it work on occasion. I've written function formulas that are nested three or four levels deep, but what the reference manuals will tell you is that they're hard to decode or understand even when they do work, and for all practical purposes impossible to maintain.
So yes, break it apart--in your case, probably into ten or twenty separate cells with ten or twenty separate results, some of them "TRUE" or "FALSE," with some kind of notation as to what each is telling you...