+ Reply to Thread
Results 1 to 4 of 4

Combine multiple formulas

  1. 01-14-2020, 04:48 PM #1
    halefamily104
    halefamily104 is offline
    Registered User
    Join Date
    09-11-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Combine multiple formulas

    Hello!

    Is there a way to combine these formula's together?

    =IF(SUMPRODUCT(--ISERROR(FIND("TX", $AA16)), --ISERROR(FIND("HV", $AA16)), --ISERROR(FIND("SRA", $AA16)), --ISERROR(FIND("GAD", $AA16)), --ISERROR(FIND("PHQ", $AA16)), --ISERROR(FIND("CSSRS", $AA16))), "", $AB16,
    IF(SUMPRODUCT(--ISERROR(FIND("TX", $AC16)), --ISERROR(FIND("HV", $AC16)), --ISERROR(FIND("SRA", $AC16)), --ISERROR(FIND("GAD", $AC16)), --ISERROR(FIND("PHQ", $AC16)), --ISERROR(FIND("CSSRS", $AC16))), "", $Ad16,
    IF(SUMPRODUCT(--ISERROR(FIND("TX", $AE16)), --ISERROR(FIND("HV", $AE16)), --ISERROR(FIND("SRA", $AE16)), --ISERROR(FIND("GAD", $AE16)), --ISERROR(FIND("PHQ", $AE16)), --ISERROR(FIND("CSSRS", $AE16))), "", $Af16,
    IF(SUMPRODUCT(--ISERROR(FIND("TX", $AG16)), --ISERROR(FIND("HV", $AG16)), --ISERROR(FIND("SRA", $AG16)), --ISERROR(FIND("GAD", $AG16)), --ISERROR(FIND("PHQ", $AG16)), --ISERROR(FIND("CSSRS", $AG16))), "", $Ah16,
    IF(SUMPRODUCT(--ISERROR(FIND("TX", $AI16)), --ISERROR(FIND("HV", $AI16)), --ISERROR(FIND("SRA", $AI16)), --ISERROR(FIND("GAD", $AI16)), --ISERROR(FIND("PHQ", $AI16)), --ISERROR(FIND("CSSRS", $AI16))), "", $Aj16)

    Thanks
    Last edited by halefamily104; 01-14-2020 at 04:54 PM.
    Reply With QuoteRegister To Reply
  2. 01-14-2020, 05:09 PM #2
    BMV
    BMV is offline
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Combine multiple formulas

    I think no without real example. And a mistake in the formula you wrote.
    Reply With QuoteRegister To Reply
  3. 01-14-2020, 05:14 PM #3
    halefamily104
    halefamily104 is offline
    Registered User
    Join Date
    09-11-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Combine multiple formulas

    Hi BMV! So there is no way to combine this formula? And you said there was a mistake in my formula? Where is it?
    Reply With QuoteRegister To Reply
  4. 01-14-2020, 05:23 PM #4
    BMV
    BMV is offline
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Combine multiple formulas

    I sad without example .
    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and
    Mistake - IF function must have minimum 2 and maximu 3 arguments. Logical test, Value if true, [Value if false] as I see
    =IF(SUMPRODUCT(...), "", $AB16, If( ….. second if is strange.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to combine multiple IF formulas at 1 cel
    By Bartman888 in forum Excel General
    Replies: 7
    Last Post: 01-31-2019, 07:37 AM
  2. [SOLVED] Combine Multiple Working IF Formulas in One Cell
    By conwaythibodeaux in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-08-2018, 06:08 PM
  3. Combine Multiple Complex Index Match Formulas to one Formula
    By Brawnystaff in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2015, 10:55 PM
  4. [SOLVED] Formula to combine multiple formulas into a single cell
    By pdx-adm-trm01 in forum Excel General
    Replies: 7
    Last Post: 03-12-2014, 02:26 PM
  5. [SOLVED] Using Combine macro to combine multiple worksheets - need to modify to paste formulas
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 09:07 AM
  6. [SOLVED] Macro to combine multiple cell formulas
    By ameerhamzauk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2012, 03:27 PM
  7. Using an IF to combine multiple formulas
    By sharkfoot in forum Excel General
    Replies: 5
    Last Post: 04-02-2006, 01:21 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1