Add Another Condition

[Chanleakna123]

HI All , 

i set formula condition as per above. but i have another condition is , If Material Code of 7770 & 7769= Discontinue . How to set such condition contains in the status formula above ? 

Your response is much appreciated. 

Thanks with regards, 
Chanleakna Hang 

[v-qiuyu-msft · Accepted solution]

Hi @Chanleakna123,

You can add a outer IF() function: 

Status= IF([Material Code]=7770 or [Material Code]=7769,"Discontinue",<your original measure>)

Best Regards,
Qiuyun Yu