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.