trying to figure out a formula

Occasional Visitor

I need an or function I think that will do the following things

my cells have s1, d1, p1, q1, q2 so on

I need a function that is cell f2=s1xxxx then j2="stage" or if f2=d1xxx then J2="Dev"

1 Reply

@amintha 

In J2:

 

=IF(LOWER(LEFT(F2,2))="s1","stage",IF(LOWER(LEFT(F2,2))="d1","Dev",""))