Combining four formulas into one single formula

**clovelly** · 02-01-2012, 03:57 AM

(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)))))))))

**Pepe Le Mokko** · 02-01-2012, 04:17 AM

Perhaps

=If(a12="","",(if(countif(B12:F12,"e"),"elim",if(b12="s","scr",if(countif(B12:F12,"w"),"W/D",if(countif(b12:f12,"r"),"ret")))))

**clovelly** · 02-01-2012, 04:48 AM

Thanks Pepe I will give it a go.
However I simplified the original formula to make it easier. I realize by doing this I may have misled you or wasted your time. The columns are not in sequence. At this stage they are columns M,S,P, and O. This may cause an issue with the countif command. I know nothing about this command and not a great deal about excel(all self taught)
Clovelly

**zbor** · 02-01-2012, 05:10 AM

Since you didn't put any order: for example B12=e and all other w what's result that you expect?

This is solution that will bring you most common output: