If you enter edit mode for the cell you can hit Alt-Enter and break the
formula up so it is easier to read. I also add spaces to act as indents so
it looks more like a structured VBA if statement.

i.e.
=if(a1="right",
"Hooray",
if(a1="wrong",
"#@$%^^#$%@!!",
"Oh Well"))

"BJ" wrote:

Hi All

I have some really large and complicated IF statements (formula type, not
VBA) that I need to review.

I seem to recall a VBA tool someone created to do this, but I can't find a
link in my favorites.

Any thoughts?

Thanks.

BJ