+ Reply to Thread
Results 1 to 8 of 8

Formula to combine multiple formulas into a single cell

  1. #1
    Registered User
    Join Date
    02-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    18

    Question Formula to combine multiple formulas into a single cell

    I'm looking for a way for Excel to combine formulas together into a more compact form for me.

    Attached is a very simple version of what I want, my actual formulas are very complex but I'd still like a way to have them automatically combined into a single cell.

    Alternatively, what is a good way to break down a very complicated one-cell formula and still keep things organized?

    **Edit: Here is the one-cell version of a formula I work with.

    Please Login or Register  to view this content.
    That formula is difficult to work with in one cell, so on another sheet I have it broken down into parts so that if one part isn't doing what I want I can change it. This takes up a LOT of space because of the other steps I do (the above formula is just one step) and I'd like to combine it together.
    Attached Files Attached Files
    Last edited by pdx-adm-trm01; 03-12-2014 at 02:09 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Formula to combine multiple formulas into a single cell

    I don't understand what you are asking. Are you wanting Excel to create formulae for you? I doubt it's possible.
    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Formula to combine multiple formulas into a single cell

    i think thats the same as

    =IF(B1*2>0,B1*2,"BAD")

    =IF(IF(B1*2>0,1,0)=1,B1*2,"BAD")

    as IF(B1*2>0,1,0)=1
    so if B1* 2 is greater than zero , that =1
    so 1=1 true
    if not than
    0=1
    is false
    so all you are checking is if
    B1*2>0
    and getting true or false
    so you can just check
    B1*2>0

    do you get the desired results ?
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Registered User
    Join Date
    02-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    18

    Re: Formula to combine multiple formulas into a single cell

    Quote Originally Posted by AliGW View Post
    I don't understand what you are asking. Are you wanting Excel to create formulae for you? I doubt it's possible.
    I have created the formulas. I want excel to put a formula into another formula for me.

    If I have cell A1 that has the formula =2+2 and cell B1 has =(A1+3) I want my output cell of C1 to copy what B1 has in this way =2+2+3.

  5. #5
    Registered User
    Join Date
    02-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    18

    Re: Formula to combine multiple formulas into a single cell

    Quote Originally Posted by etaf View Post
    i think thats the same as

    =IF(B1*2>0,B1*2,"BAD")

    =IF(IF(B1*2>0,1,0)=1,B1*2,"BAD")

    as IF(B1*2>0,1,0)=1
    so if B1* 2 is greater than zero , that =1
    so 1=1 true
    if not than
    0=1
    is false
    so all you are checking is if
    B1*2>0
    and getting true or false
    so you can just check
    B1*2>0

    do you get the desired results ?
    The formula I posted is an simplified example. It doesn't matter what the formula is. I did not explain myself correctly.

    I want excel to combine formulas from multiple cells into a single cell. That way if there is a problem I can examine the expanded version of a complicated formula over multiple cells in one sheet, then combine them together so that I can save space on another sheet.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Formula to combine multiple formulas into a single cell

    But how could Excel possibly know what the relationship between each of the mini-formulae was? Only you know that. I have done similar things myself when creating very complex formulae, and the building has to be manual because of getting the syntax and order of calculations right.

  7. #7
    Registered User
    Join Date
    02-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    18

    Re: Formula to combine multiple formulas into a single cell

    Quote Originally Posted by AliGW View Post
    But how could Excel possibly know what the relationship between each of the mini-formulae was? Only you know that. I have done similar things myself when creating very complex formulae, and the building has to be manual because of getting the syntax and order of calculations right.
    So there's no way to automatically replace every "B1" in a formula with the formula that appears in B1?

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Formula to combine multiple formulas into a single cell

    Not that I know of, no. The INDIRECT function won't allow it. Only the result of the formula in the cell can be referenced.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. formula to combine multiple cells into single cell where reference is same
    By rexer231 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2014, 11:44 AM
  2. [SOLVED] How do I combine multiple lines of information into a single cell, separated by commas?
    By ilostar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2012, 11:48 AM
  3. [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
  4. Need multiple formulas in single cell
    By Deltaeagle in forum Excel General
    Replies: 2
    Last Post: 07-10-2009, 09:04 AM
  5. [SOLVED] Using a single cell in multiple formulas
    By ebethcat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 05:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1