Mar 16 2021 09:02 AM
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"
Mar 16 2021 09:20 AM
@amintha
In J2:
=IF(LOWER(LEFT(F2,2))="s1","stage",IF(LOWER(LEFT(F2,2))="d1","Dev",""))