+ Reply to Thread
Results 1 to 7 of 7

Help Combining Two Formula's In One Cell

  1. #1
    Forum Contributor
    Join Date
    07-15-2007
    Location
    Bend, Oregon
    MS-Off Ver
    Office 2016 Windows
    Posts
    156

    Help Combining Two Formula's In One Cell

    Hello,

    I am trying to combine two formula's into one cell, F2.

    The two formulas are below, D2=24

    =D2*1.12

    and =F2/(1-10%)

    And end result in F2 should be 30

    Thanks JR
    Last edited by gaspower; 09-21-2015 at 10:59 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Help Combining Two Formula's In One Cell

    Don't think an equation in a cell can reference its own cell. F2 can't contain a formula including =F2.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Help Combining Two Formula's In One Cell

    Try this

    =D2*1.12/(1-10%)

    the result is: 29.86666667
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Help Combining Two Formula's In One Cell

    gaspower, Good morning.

    Try to use:

    F2 --> =(D2*1.12)/(1-10%)

    OR

    F2 --> =(D2*1.12)/0.9

    Is that what you're lokiing fo?
    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marc?lio Lob?o

  5. #5
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Help Combining Two Formula's In One Cell

    =(D2*1.12)/.9

    (.9 is 1- 10%) if you want to use (D2*1.12)/(1-.1) you can

  6. #6
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Help Combining Two Formula's In One Cell

    sorry did not see the other two replies... refresh is you friend

  7. #7
    Forum Contributor
    Join Date
    07-15-2007
    Location
    Bend, Oregon
    MS-Off Ver
    Office 2016 Windows
    Posts
    156

    Re: Help Combining Two Formula's In One Cell

    Hello Alkey,

    That worked perfect. Thank you

+ 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. Combining a formula with a cell search from a different spreadsheet
    By Federer18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2014, 02:51 PM
  2. [SOLVED] Combining text and formula into a single cell
    By jager in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2013, 08:12 PM
  3. Replies: 1
    Last Post: 10-15-2010, 05:44 AM
  4. Combining formula and cell reference
    By Drew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2006, 05:55 AM
  5. [SOLVED] Help on combining declared variable and cell formula
    By sylink in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2005, 06:05 PM
  6. Help on combining declared variable and cell formula
    By sylink in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2005, 03:05 PM
  7. Combining Text and Date Formula in same cell
    By Komatsu in forum Excel General
    Replies: 1
    Last Post: 04-26-2005, 12:42 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