Reviewing Large IF statements

Reviewing Large IF statements - Any tools?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BJ - 28 May 2008 20:04 GMT

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

Reply to this Message

Hemang Dave - 28 May 2008 20:29 GMT

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

> Hi All
>
[quoted text clipped - 9 lines]
>
> BJ

Reply to this Message

JNW - 28 May 2008 20:36 GMT

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

> Hi All
>
[quoted text clipped - 9 lines]
>
> BJ

Reply to this Message

Gary Keramidas - 28 May 2008 20:44 GMT

smart indenter may help sort it out, too.

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

Signature

Gary

> Hi All
>
[quoted text clipped - 9 lines]
>
> BJ

Reply to this Message

Bob Phillips - 28 May 2008 22:11 GMT

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

Signature

---
HTH

Bob

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

> smart indenter may help sort it out, too.
>
[quoted text clipped - 14 lines]
>>
>> BJ

Reply to this Message

Gary Keramidas - 28 May 2008 22:34 GMT

sorry must have missed that part.

knew we kept you around for something<g>

Signature

Gary

> <quote>
> I have some really large and complicated IF statements (formula type, not
[quoted text clipped - 18 lines]
>>>
>>> BJ

Reply to this Message

Gary Keramidas - 28 May 2008 20:47 GMT

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

Signature

Gary

> Hi All
>
[quoted text clipped - 9 lines]
>
> BJ

Reply to this Message