+ Reply to Thread
Results 1 to 5 of 5

Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

  1. #1
    Registered User
    Join Date
    10-24-2005
    Location
    Lake Forest, CA
    MS-Off Ver
    2007
    Posts
    56

    Cool Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

    If column N "Resolution Date" is blank, result is blank
    If Column N is not blank, then subtract Resolution Date from Colum M" Submit Date" result is Days to Approve

    This formula has been working, but isn't working today
    =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

    (Computer upgraded to Win 10 & Office 2013 (not sure if this made a difference or not)

    Column M N O
    Label Submit Date Resolution Date Days to Approve
    Sample1 2/16/17 2/16/17 0
    Sample 2 2/6/17 blank blank
    Sample 3 2/6/17 2/7/17 2

    Help Please

  2. #2
    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 not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

    Not sure why double this IF(ISBLANK(N4),"",IF(ISBLANK(N4)
    Try this one
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    You may also try these two
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by AlKey; 02-17-2017 at 12:09 PM.
    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

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

    What I see is that the formula is checking N4 twice, which seems odd, is it supposed to check N then M?
    When you say "is not working" what do you mean exactly? formula returns an error, does not put blank when N4 is blank, doesn't do the subtraction....
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Registered User
    Join Date
    10-24-2005
    Location
    Lake Forest, CA
    MS-Off Ver
    2007
    Posts
    56

    Re: Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

    That worked

    I figure someone messed with the formula, but I couldn't remember what the original formula was

    Thanks a bunch!!!

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

    Glad it was sorted, I'm assuming AlKey's post is the one that did it. If the issue is fixed please remember to 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)

Similar Threads

  1. [SOLVED] Link excel file to workbook "=IF(ISBLANK('Sheet1!A1),"",'Sheet1!A1) " is this reliable?
    By bala04msw in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-29-2016, 05:39 AM
  2. [SOLVED] Clean up If/Then formula, adding in "isblank" range
    By snuffnchess in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-08-2016, 02:16 PM
  3. [SOLVED] Writing =IF(ISBLANK($H4), "", VLOOKUP($H4,DCID[#All], 3, FALSE)) to a cell and work
    By smit.etha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2015, 04:36 PM
  4. ISBLANK() not working with "R1C1" reference
    By riwiseuse in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-24-2015, 08:21 PM
  5. [SOLVED] IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2014, 02:37 PM
  6. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  7. Replies: 6
    Last Post: 09-08-2011, 02:04 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