Posted to microsoft.public.excel.programming

ExcelMonkey ExcelMonkey is offline

external usenet poster

Posts: 553

Counting Nested If Statements

Can anyone tell me how to count nested if statements in a formula via VBA.
That is I want to be able to go into a cell and assess that the formula below
has three IF stmts

=IF(XXXXXXX,IF(XXXXXXX, IF(XXXXXX)))

This may be a Regular Expression question.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nested IF statements	TwoDot	Excel Worksheet Functions	4	February 8th 07 12:17 AM
Nested if statements - is there a better way?	masterbaker	Excel Worksheet Functions	3	July 25th 06 04:59 PM
Nested IF statements	maacmaac	Excel Discussion (Misc queries)	2	January 23rd 06 10:18 PM
Nested IF statements	John Simons	Excel Worksheet Functions	14	February 16th 05 06:17 AM
nested statements	Sherri	New Users to Excel	6	December 3rd 04 07:04 PM

All times are GMT +1. The time now is 05:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us