# Combining four formulas into one single formula

1. ## Combining four formulas into one single formula

(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

2. ## Re: Combining four formulas into one single formula

Perhaps
``Please Login or Register  to view this content.``

3. ## Re: Combining four formulas into one single formula

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

4. ## Re: Combining four formulas into one single formula

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:

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1