+ Reply to Thread
Results 1 to 5 of 5

Correction to a formula

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    221

    Correction to a formula

    =IF(E14="",0,S9)

    The above is the formula in the cell and instead of it being S9 I need it to be the total of S9+S10

    I have tried (S9+S10)) which is the obvious to me but its not working

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Correction to a formula

    Mike, that should work. =IF(E14="",0,S9+S10)

    What do you have in those 2 cells (exactly)?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  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: Correction to a formula

    maybe this

    =IF(E14="",0,SUM(S9,S10))
    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
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Correction to a formula

    Perfect Thanks

  5. #5
    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: Correction to a formula

    Thank you for the feedback!

+ 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. [SOLVED] Correction of formula.
    By hecgroups in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-19-2013, 12:41 PM
  2. Formula Correction Help?
    By Const Consult in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-18-2009, 03:02 PM
  3. [SOLVED] correction of formula please............
    By azmi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2005, 04:05 PM
  4. [SOLVED] Re: Formula correction HELP!!!
    By Jay in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-02-2005, 04:06 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