Jump within IF statement?

[MLT]

I'm not sure if I can type my example here since its a diagram, so
I'll try to explain generally what I'm trying to do.

I made a tree diagram starting at the top with a question, which then
branches into two branches for yes or no - IF(question here,yes
action,no action). Now the tricky part is, I've gotten to a "no"
branch where the action is the same as a "no" branch that is further
up the diagram. Is it possible to tell the function to "jump" to
another section within the same formula?

 

[Joe User]

Is it possible to tell the function to "jump"
to another section within the same formula?

Yes, if you are talking about VBA IF statements. But that might not be the
best form to use.

No, not if you are talking about Excel IF expressions. But it might not be
too difficult to form the correct construction. Sometimes it is best to
duplicate parts of the IF expression. Sometimes there are alternatives that
avoid duplication.

We might be able to help if you describe your flow chart in words.


----- original message -----