+ Reply to Thread
Results 1 to 6 of 6

Blank cell condition in formula

  1. #1
    Forum Contributor
    Join Date
    01-06-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    209

    Blank cell condition in formula

    I have a formula working, but if K3 has a date in it and j3 is blank I get the serial of the date I want a blank in the cell

    =IF(K3="",IF(J3<>"",IF(AND(DATEDIF(J3,TODAY(),"d")>=7,K3=""),"Chase Up",""),""),DATEDIF(J3,K3,"d"))

    Thank you for any help
    Last edited by UltimateNeo; 09-22-2019 at 11:48 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,720

    Re: Formulas

    You should really change your thread title, to make it describe what you want to achieve - see Rule 01 of the Forum Rules at the top of the screen.

    Pete

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,075

    Re: Formulas

    How about
    =IF(J3="","",IF(K3="",IF(DATEDIF(J3,TODAY(),"d")>=7,"Chase Up",""),DATEDIF(J3,K3,"d")))

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: Formulas

    Ultimate Neo. You've been here for a while and have lots of posts. By now, you should realise that your title is too weak. If you had been doing a Google search for an answer.... what search term would you have used? That's what we expect to see, not your chosen title, which would yield a squillion useless hits.

    Normally, I would lock the thread down and require you to make the change yourself. However, since you may already have an answer, that seems a bit pointless. However, do please take a moment to come up with a better title and change the thread title YOURSELF. If the answer is not what you need and you do not change the title, I WILL lock the thread UNTIL you make a suitable change.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: Blank cell condition in formula

    UltimateNeo... thanks for making the change.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,075

    Re: Blank cell condition in formula

    @UltimateNeo
    Thanks for the Rep

+ 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. Copy Formulas from 'Formulas' Sheet into Data Table Columns
    By Jonny757 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2020, 08:18 PM
  2. Make model faster: convert formulas to text and then back to formulas
    By lucassdm7 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-25-2019, 06:49 AM
  3. Replies: 9
    Last Post: 12-04-2015, 05:19 PM
  4. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  5. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  6. Help modifying macro to wrap iferror formulas around existing formulas
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:04 PM
  7. Replies: 5
    Last Post: 05-05-2008, 02:22 PM

Tags for this Thread

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