+ Reply to Thread
Results 1 to 11 of 11

Formula to Add Two Cells Together with Seperate Formulas

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Formula to Add Two Cells Together with Seperate Formulas

    Hello,
    I need help with creating a formula. The result needs to be adding together two cells which have a multiplication for each. I want the results cell to have a blank result if it is zero. Here is what I have, but cell 890 and 891 are not adding their results together:
    (note: cell 890 will be blank until I enter a value, and cell 891 will always have a fixed value).

    Cell 890 and 891 will always be multiplied by the same value (9%), so maybe they should be added together first, then multiplied by 9%?

    As this string now stands, the result cell is only showing the multiplication of cell 890

    =IF(F890=0,"",(F890*0.09)+(F891*0.09))

    Thank you
    Last edited by lisapar; 03-13-2014 at 09:48 AM. Reason: vague title

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,503

    Re: Need forumla

    First off, I'm not sure your post meets forum rule #1 about vague titles. So you may get a ding from a moderator.
    That being said, I created dummy data, plugged in your formula and it seems to be working whether I add them first or use the formula to do it. So what exactly is your problem? If they are not adding together maybe either cell is in as text or has something hidden like a carriage return?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    12-16-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: Need forumla

    Your formula worked for me but you might try putting another set of brackets on

    =IF(c890=0,"",((c890*0.09)+(c891*0.09)))

    http://www.easyexcelanswers.com

  4. #4
    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: Need forumla

    Try this one

    =IF(F890=0,"",SUM(F890*0.09,F891*0.09))
    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

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need forumla

    oops never saw the title
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  6. #6
    Registered User
    Join Date
    03-13-2014
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Formula to Add Two Cells Together with Seperate Formulas

    To the moderator -- I apologize for the vague title and it has been updated.

    To all responses, thank you. I tried the suggested formulas and they didn't work. I will try to be more detailed:

    Cell 890 has a value of 29.71
    Cell 891 has a value of 5.50

    In cell 892, I need a formula to multiply cell 890 by 0.09% (29.71 x 0.09 = 2.67),
    and also multiply cell 891 by 0.09% (5.50 x 0.09 = .50), and then add 2.67 + .50 for a result sum of 3.17 in cell 892.
    If there is no value in cell 890, I wish the cell to be blank

    Thank you!

  7. #7
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,503

    Re: Formula to Add Two Cells Together with Seperate Formulas

    I tried your numbers in my data and blanked out your cell 890 and got the results you want.
    If 29.71 in 890 and 5.5 in 891 I get 3.1689 in 892, if I null out 890 I get a blank in 892. Not sure what is different for you.

    EDIT, and i get it whether I use your formula, the one from easyexcelanswers or the one from AlKey.
    Last edited by Sam Capricci; 03-13-2014 at 10:12 AM.

  8. #8
    Registered User
    Join Date
    03-13-2014
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Formula to Add Two Cells Together with Seperate Formulas

    Got it to work! I was missing a bracket! Thanks everyone!

  9. #9
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,503

    Re: Formula to Add Two Cells Together with Seperate Formulas

    Being new to the forum you might not know that those who helped you (any or all) can be thanked by adding to their reputation at the bottom of their posts.
    And BTW you can mark your post as solved by using the thread tools at the top of the post.

    Thanks for the feedback.
    Last edited by Sam Capricci; 03-13-2014 at 10:28 AM.

  10. #10
    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: Formula to Add Two Cells Together with Seperate Formulas

    Thanks for the feedback!

  11. #11
    Registered User
    Join Date
    03-13-2014
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Formula to Add Two Cells Together with Seperate Formulas

    Done. Thanks again for the guidance.

+ 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. Conditional Forumla with Forumla assigned- Help needed
    By MarkoPolo in forum Excel General
    Replies: 3
    Last Post: 03-06-2014, 06:46 PM
  2. [SOLVED] Does SUM contain a value - Forumla
    By wrightyrx7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2014, 05:53 AM
  3. [SOLVED] Excel 2007 : Need Help with a forumla (If-Then)
    By MuhammadSami in forum Excel General
    Replies: 5
    Last Post: 10-07-2011, 06:49 AM
  4. [SOLVED] Forumla
    By Don in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. Replacing a cell's forumla with the forumla's results?
    By Mooncalf in forum Excel General
    Replies: 2
    Last Post: 01-04-2005, 12:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1