+ Reply to Thread
Results 1 to 4 of 4

Combining four formulas into one single formula

  1. #1
    Registered User
    Join Date
    01-24-2012
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    32

    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
    =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)))))))))
    Last edited by clovelly; 02-03-2012 at 06:40 AM. Reason: SOLVED & to add solution

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,973

    Re: Combining four formulas into one single formula

    Perhaps
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-24-2012
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    32

    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. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    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:
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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