Hi everyone,

Im trying to design a function which would essentially split out a formula into it's constituent parts and "rank" each node according to where it sits on the formula hierarchy. So for example, if I have the formula:

=IF(A1=2,SUM(A2:A6),IF(A1=3,SUM(B2:B6),0))

Would split out to
Level 1: IF (first IF)
Level 2: SUM, IF (TRUE and FALSE terms of first IF)
Level 3: SUM (TRUE statement of second IF)

I already have a vba function which can split out which functions are used in a given formula, so what I already have will give:

IF,SUM,IF,SUM,

Any ideas?

Thanks!

Craig