+ Reply to Thread
Results 1 to 8 of 8

How to combine multiple IF formulas at 1 cel

  1. 01-31-2019, 07:08 AM #1
    Bartman888
    Bartman888 is offline
    Registered User
    Join Date
    07-25-2018
    Location
    The Netherlands
    MS-Off Ver
    16.15
    Posts
    18

    Question How to combine multiple IF formulas at 1 cel

    I would like to have multiple IF rules combined in 1 cel. These are the 3 rules I would like to combine:

    =IF(AND(E26="*";E25="*");N27-N26-N25)
    =IF(E26="*";N27-N26)
    =IF(AND(E26="";E25="");N27)

    Can somebody tell me how to put this all together in 1 cel so it gives the solution on 1 of these formules?

    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 01-31-2019, 07:18 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,642

    Re: How to combine multiple IF formulas at 1 cel

    Try
    =IF(AND(E26<>"",E25<>""),N27-N26-N25,IF(E26<>"",N27-N26,IF(AND(E26="",E25=""),N27,"")))

    adapt to you regional settings
    Reply With QuoteRegister To Reply
  3. 01-31-2019, 07:24 AM #3
    Bartman888
    Bartman888 is offline
    Registered User
    Join Date
    07-25-2018
    Location
    The Netherlands
    MS-Off Ver
    16.15
    Posts
    18

    Re: How to combine multiple IF formulas at 1 cel

    Thanks. I did this but I cannot save it because it marks the ""

    =ALS(EN(E26<>"",E25<>""),N27-N26-N25,ALS(E26<>"",N27-N26,ALS(EN(E26="",E25=""),N27,"")))
    Reply With QuoteRegister To Reply
  4. 01-31-2019, 07:31 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,642

    Re: How to combine multiple IF formulas at 1 cel

    Did you replace commas with semicolons?
    Reply With QuoteRegister To Reply
  5. 01-31-2019, 07:31 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,917

    Re: How to combine multiple IF formulas at 1 cel

    Try this:

    =ALS(EN(E26<>"";E25<>"");N27-N26-N25;ALS(E26<>"";N27-N26;ALS(EN(E26="";E25="");N27;"")))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 01-31-2019, 07:34 AM #6
    Bartman888
    Bartman888 is offline
    Registered User
    Join Date
    07-25-2018
    Location
    The Netherlands
    MS-Off Ver
    16.15
    Posts
    18

    Re: How to combine multiple IF formulas at 1 cel

    I don't know what you mean, sorry
    Reply With QuoteRegister To Reply
  7. 01-31-2019, 07:36 AM #7
    Bartman888
    Bartman888 is offline
    Registered User
    Join Date
    07-25-2018
    Location
    The Netherlands
    MS-Off Ver
    16.15
    Posts
    18

    Re: How to combine multiple IF formulas at 1 cel

    Hi, thanks! Yes, this works . You're the best!
    Reply With QuoteRegister To Reply
  8. 01-31-2019, 07:37 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,917

    Re: How to combine multiple IF formulas at 1 cel

    All I did was what Pepe told you to do in post #4.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    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. [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
  2. 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
  3. [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
  4. [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
  5. [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
  6. Using an IF to combine multiple formulas
    By sharkfoot in forum Excel General
    Replies: 5
    Last Post: 04-02-2006, 01:21 PM
  7. [SOLVED] Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas
    By John in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-25-2005, 03:43 AM

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