Finding out the resulting action of a very long nested IF

[MinhTNguyen]

I have a problem with a very long nested if formula (~10 level deep) that contain even more logical And statement in 1 IF, and at each level return a formula
i have tried the evaluation function but it return "2" directly
Ex: =IF(...IF(...IF(...IF(...IF(...,1+1,)...))))) ; i want to get "1+1" and not "2"

What i aim to do is analyze the formula with vba and return just the last resulting formula it use to calculate the end Value for the ease of understanding when other peoples read it

My current idea is to write all the last resulting formula in vba and compare it to the cell containing the If statement, but here lies the problem: Due to customizability of the table, the vba code wont be sure of which column it is on to compare the right set of formula to the If statement

 

[SanjayGMusafir]

I have a problem with a very long nested if formula (~10 level deep) that contain even more logical And statement in 1 IF, and at each level return a formula
i have tried the evaluation function but it return "2" directly
Ex: =IF(...IF(...IF(...IF(...IF(...,1+1,)...))))) ; i want to get "1+1" and not "2"

What i aim to do is analyze the formula with vba and return just the last resulting formula it use to calculate the end Value for the ease of understanding when other peoples read it

My current idea is to write all the last resulting formula in vba and compare it to the cell containing the If statement, but here lies the problem: Due to customizability of the table, the vba code wont be sure of which column it is on to compare the right set of formula to the If statement

There is one way of doing it - but need some precautions with it

• You can evaluate each statement by pressing F9 (check shortcut for your version)
• It shall generate result for selected condition only
• REMEMBER, to undo (Ctrl+Z) immediately after testing every condition else the value will become part of formula
  • You can't do multiple UNDO by testing one condition after another

Hope it helps you in some way.