Excel- Progress tree formula

BDickson February 9, 2009 at 15:57:03
Specs: Windows XP
 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

See More: Excel- Progress tree formula

#1
February 9, 2009 at 18:39:21
 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.

Report •

#2
February 10, 2009 at 10:00:19
 DerbyDad03Thanks for your help. Helped me with the formula and I understand it better now too.I think can make my own.Thanks again.

Report •

Related Solutions