(Solved)The following formula is not working the way we need
=IF(A12="","",(IF(OR(M12="e",M12="s",M12="r",M12="w",S12="e",S12="r",S12="w",P12="e",P12="r",P12="w",O12="e",O12="w",O12="r",W12="e",W12="w","),"E",SUM(M12+Z12+AC12))))
Instead of just showing E I need to show any one of E,R,W,S
A combination of the four formulas below should accomplish what is required.
=IF(A12=,,(IF(OR(M12=e,S12=e,P12=e,O12=e,W12=e,ELIM))))
=IF(A12=,,(IF(M12=s,SCR)))
=IF(A12=,,(IF(OR(M12=w,S12=w,P12=W,O12=w,W12=w,W/D))))
=IF(A12=,,(IF(OR(M12=r,S12=r,P12=r,O12=r,W12=r,RET))))
I've tried quite a few different combinations, but get the same message - to many arguments.
Any assistance would be greatly appreciated.
This solution has different columns than the sample above. It is taken directly from our woorkbook , it seems to work OK
=IF(M5="","",IF(OR(M5="e",P5="e",Q5="e",R5="e",Z5="e"),"ELIM",(IF(OR(M5="s"),"SCR",(IF(OR(M5="w",P5="w",Q5="W",R5="w",Z5="w"),"W/D",(IF(OR(M5="r",P5="r",Q5="r",R5="r",Z5="r"),"RET",SUM(AD5+Y5+AA5)))))))))
Bookmarks