Complex Formula

[Steve Scott]

I am trying to extend an already long formula which uses multiple nested IIf
statements. I keep getting lost as to the number of brackets required at
each stage and at the end. is there a tool that anyone knows of that allows
me to type in my statements and then it will generate the correct formula for
me?

Thanks

 

[Rob Schneider]

Understand the problem. When my brain hurts with too many brackets, I
paste the formula into the editor I typically use, called jEdit (freely
available at www.jedit.org) and it has functionality to display bracket
pairs. After getting it right, paste back into Project.