aminthaCopper ContributorMar 16, 2021trying to figure out a formula 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" Show More
HansVogelaarMVPMar 16, 2021amintha In J2: =IF(LOWER(LEFT(F2,2))="s1","stage",IF(LOWER(LEFT(F2,2))="d1","Dev",""))
