Forum Discussion
Solved
Add Another Condition
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
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
1 Reply
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