IF statement selected values

[Anonymous]

i need a frormula if an employee has only step ID "Plan+DO+Act"then give me as result succeed. see picture below

[tex628]

How many different distinct values are there in "Step ID"?

[Anonymous]

We have in total 10. and every time it's another formula. so one formula is step ID 1,3 and 5. other formula is step ID 6,2,8

[tex628 · Accepted solution]

I would say create a numeric column, converting the text values of Step ID to numeric values. Then sum them together to determine which combination it is. 

For example 
6 + 2 + 8 = 16 = "Pending" 
1 + 3 + 5 = 9 = "Initiated"

You just have to make sure that the combinations aren't intersecting, so i wouldn't use something so simple as 1-10!