Reviewing Large IF statements - Any tools?
 

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

Reviewing Large IF statements - Any tools?
 

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

"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

Reviewing Large IF statements - Any tools?
 

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

Reviewing Large IF statements - Any tools?
 

smart indenter may help sort it out, too.

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

--


Gary


"BJ" wrote in message
...
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

Reviewing Large IF statements - Any tools?
 

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

--


Gary


"BJ" wrote in message
...
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

Reviewing Large IF statements - Any tools?
 

<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" <GKeramidasATmsn.com wrote in message
...
smart indenter may help sort it out, too.

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

--


Gary


"BJ" wrote in message
...
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

Reviewing Large IF statements - Any tools?
 

sorry must have missed that part.

knew we kept you around for something<g

--


Gary


"Bob Phillips" wrote in message
...
<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" <GKeramidasATmsn.com wrote in message
...
smart indenter may help sort it out, too.

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

--


Gary


"BJ" wrote in message
...
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