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

Do you think Google should sell budget phones in the US?

Discuss in The Lounge

Poll History