+ Reply to Thread
Results 1 to 3 of 3

IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))

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

    Unhappy IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))

    Hope you can help me again. While out of the office, another column was added to my report. I should be able to simply adjust the column references, but it isn't working. All cells come back blank. No errors and no proper results. I am flummoxed. This was working in December. Can't figure out why it won't work now.

    =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))

    Formula is in cell O3 (Days Pending)
    M3 = Resolution Date, may or may not be blank
    L3 = Submit Date, may or may not be blank


    If Resolution date is blank and submit date is blank, result is blank
    If Resolution date is not blank and submit date is not blank, result is blank

    If Resolution date is blank, but Submit date has a value, subtract todays date from Submit date to provide the number of days the item has been pending.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))

    Maybe:

    =IF(AND(M3="",L3<>""),TODAY()-L3,"")
    Quang PT

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

    Re: IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))

    Thanks! That seems to have done the trick!!

+ 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. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. 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
  3. Replies: 6
    Last Post: 09-08-2011, 02:04 PM
  4. Replies: 1
    Last Post: 11-24-2010, 08:35 AM
  5. Replies: 5
    Last Post: 10-12-2010, 06:46 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