+ Reply to Thread
Results 1 to 4 of 4

Using an IF statement, want to leave a column blank if another has no value

  1. #1
    Registered User
    Join Date
    04-11-2016
    Location
    Leeds, England
    MS-Off Ver
    2010
    Posts
    2

    Using an IF statement, want to leave a column blank if another has no value

    I am making a basic project tracker which has a Target Finish, Days Left and a Date Cleared column. Currently the Days left column autocompletes from the Target Finish and if there is a Date Cleared entry then the Days left becomes Complete. However if I don't have any value in Target finish then Days left becomes -42471. I want to edit my formula to make it so if there is no Target finish date nothing shows up in Days left.

    My formula is currently =IF(ISBLANK([@[Date Cleared]]),[@[Target Finish]]-TODAY(),"Complete")

    File attached
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Using an IF statement, want to leave a column blank if another has no value

    Try this...

    =IF(AND([@[Target Finish]]="",[@[Date Cleared]]=""),"",IF(ISBLANK([@[Date Cleared]]),[@[Target Finish]]-TODAY(),"Complete"))

  3. #3
    Registered User
    Join Date
    04-11-2016
    Location
    Leeds, England
    MS-Off Ver
    2010
    Posts
    2

    Re: Using an IF statement, want to leave a column blank if another has no value

    That is brilliant, thank you very much

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Using an IF statement, want to leave a column blank if another has no value

    You're welcome.

+ 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. Create an if statement in VB to display value or leave blank.
    By Talk_4 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-03-2015, 03:02 AM
  2. Summing Cells that contain an IF Statement to leave the cell blank if zero
    By sweeteri in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-14-2014, 12:58 PM
  3. IF Statement to leave cell blank if multiple cells are all blank
    By sweeteri in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-14-2014, 12:02 PM
  4. Replies: 4
    Last Post: 06-24-2013, 07:17 AM
  5. MS 2010 - IF Statement to reutrn date or leave cell blank
    By persais in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-14-2013, 02:48 PM
  6. IF Statement to leave cell completely blank
    By david1987 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2012, 10:27 AM
  7. Search column and if results found put an X if not leave blank
    By slo5oh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2011, 09:32 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