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

Report •


#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
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.


Report •

Related Solutions


Ask Question