+ Reply to Thread
Results 1 to 9 of 9

total not required before other cells are written in

  1. #1
    Registered User
    Join Date
    09-06-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    11

    total not required before other cells are written in

    I am having problems with a formula.
    I need to put a total in a cell, 50 points minus two other cells. The trouble is that the 50 comes up all the time and I want it to just say 0 when I haven’t enter an amount in AI18 and AJ18. Any suggestions?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: total not required before other cells are written in

    Try this:

    =IF(COUNT(AI18:AJ18)=2, 50-SUM(AI18:AJ18), 0)
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-06-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: total not required before other cells are written in

    excel is saying there is a mistake :-(

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: total not required before other cells are written in

    if you post a book it would be easier but i cant see why that formula wouldnt work!
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  5. #5
    Registered User
    Join Date
    09-06-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: total not required before other cells are written in

    I am new to "excel" what is a "book"?

  6. #6
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: total not required before other cells are written in

    as in your workbook the excell file your using when you post click go advanced then click the atach icon and attach it (a sample if the data is sensative)

  7. #7
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: total not required before other cells are written in

    or try this

    Please Login or Register  to view this content.
    it was pointed out to me that your version of excel may use ; instead of the , in formulas

  8. #8
    Registered User
    Join Date
    09-06-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: total not required before other cells are written in

    I have been playing around with the formula and this seems to work

    =IF(AI18+AJ18<1;"0";50-AI18-AJ18)

    thanks for the help.

  9. #9
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: total not required before other cells are written in

    I have marked this thread solved for you.
    In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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