Reviewing Large IF statements - Any tools?

[BJ]

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

 

[Hemang Dave]

Hi BJ

you might wanna try the formula auditing toolbar in excel. It's in
Tools/Formula Auditing.

Alternatively, within Formula auditing Evaluate formula is very useful. it's
more like watch variable debugging tool in C++.

Cheers
-HD

 

[JNW]

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"))

 

[Gary Keramidas]

smart indenter may help sort it out, too.

http://www.oaltd.co.uk/Indenter/Default.htm

 

[Gary Keramidas]

and this print utility may also help, though it's not free, you can try it for
30 days

http://submain.com/?nav=products.pcp

 

[Bob Phillips]

<quote>
I have some really large and complicated IF statements (formula type, not
VBA) ...
</quote>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gary Keramidas]

sorry must have missed that part.

knew we kept you around for something<g>