Dear Experts,
I am hoping to get help from this forum, see below my comment and the work book attached.
I am hoping to get help from this forum, see below my comment and the work book attached.
If D5, E5, F5, G5, H5... = C,Z,"" give "Comp" if there is any other values other than or along with C,Z,"" in cell D5, E5, F5, G5, H5... then give "No". for example if any the cells contains O,I,C,Z,"" then give "No" here is my formula working which is not working. Please see formulas Col. P Q R in sheet 1 IF(OR(D5="C",E5="C",F5="C",G5="C",H5="C",I5="C",J5="C",K5="C"),IF(OR(D5="",E5="",F5="",G5="",H5="",I5="",J5="",K5=""),IF(OR(D5="z",E5="Z",F5="Z",G5="Z",H5="Z",I5="Z",J5="Z",K5="Z"),"Complete","No"))) Thank you folks.View attachment IF OR AND Formula fix.xlsx |