I am curious how to make a Progression tree in excel and I am not knowledgeable enough to figure it out (self taught so far). I am trying to figure out how to make the formula work so when A2 has the value of: “condition1” it does the following formula.

=IF(A1<=40,"RL",IF(A1>=41,"EL"))

But when A2 has the value of: “condition2” it does this formula:

=IF(A2="condition2","SC")

Thanks for your help my friends.

-BD

With the following formula in any cell (other than A1 or A2, obviously) you'll get RL or EL if A2 = 1, otherwise you'll get SC: =IF(A2=1,IF(A1<=40,"RL",IF(A1>=41,"EL")),"SC")

With this one, you'll get RL or EL if A2 = 1, SC if A2 = 2 and an empty cell if A2 <> 1 or 2:

=IF(A2=1,IF(A1<=40,"RL",IF(A1>=41,"EL")),IF(A2=2,"SC",""))

Hope that helps.

DerbyDad03 Thanks for your help. Helped me with the formula and I understand it better now too.I think can make my own.

Thanks again.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History