+ Reply to Thread
Results 1 to 5 of 5

Display blank cell if previous cell is blank in formula

  1. #1
    Registered User
    Join Date
    09-29-2016
    Location
    San diego
    MS-Off Ver
    2013
    Posts
    2

    Display blank cell if previous cell is blank in formula

    Hi,

    I am using this formula:
    =WORKDAY(E6,1,Sheet2!$J$7:$J$24)
    But, if E6 is blank, I want the cell containing the formula, to be blank.

    I can no longer pound my head on my desk

    Thanks in advance.
    Brent

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Display blank cell if previous cell is blank in formula

    Try

    =IF(E6="","",WORKDAY(E6,1,Sheet2!$J$7:$J$24))

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Display blank cell if previous cell is blank in formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    09-29-2016
    Location
    San diego
    MS-Off Ver
    2013
    Posts
    2
    Quote Originally Posted by JohnTopley View Post
    Try

    =IF(E6="","",WORKDAY(E6,1,Sheet2!$J$7:$J$24))
    It worked great!!!
    Thank you

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Display blank cell if previous cell is blank in formula

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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: 1
    Last Post: 07-22-2016, 04:03 PM
  2. formula to determine which cell is NOT blank and display that cell's text?
    By LWSheehan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2015, 08:54 PM
  3. If cell blank OR another cell blank then show blank, if not display value
    By stevop622 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-09-2013, 04:07 AM
  4. Replies: 0
    Last Post: 10-05-2012, 09:27 AM
  5. Replies: 1
    Last Post: 04-30-2012, 06:02 AM
  6. Replies: 12
    Last Post: 05-04-2010, 04:35 AM
  7. [SOLVED] how to get excel to display blank if reference cell blank
    By silent1(not) in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2005, 10:55 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