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


In J2: