+ Reply to Thread
Results 1 to 4 of 4

If blank then display blank

  1. #1
    Registered User
    Join Date
    09-14-2020
    Location
    Valdosta, GA
    MS-Off Ver
    Office 2019
    Posts
    18

    If blank then display blank

    Good day all.

    I am trying to display a blank cell if blank, nut I already have a formula in the cell.

    Explination:

    - I am tracking weeks below 70% in column L.

    - In column K, I input the date the percentage fell below 70%. Bonus if the cell can auto populate the day it falls below 70% and remove once it goes above. (if bonus cred can be given)(not priority, a nice to have)

    - Main issue: I want to display a blank cell in Column L if the date in Column K is blank, and keep my formula in Column L. AS you can see Column L displays over 6000 weeks if K is blank.

    I have searched online and through here and cannot seem to find what I am looking for.

    Thank you

    Nvable.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    12,988

    Re: If blank then display blank

    In L2 copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Does that work for you?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    09-14-2020
    Location
    Valdosta, GA
    MS-Off Ver
    Office 2019
    Posts
    18

    Re: If blank then display blank

    ChemistB,

    Thank you for your response. I will let you know tomorrow. The file is at work.

    Thank you again.

    Nvable

  4. #4
    Registered User
    Join Date
    09-14-2020
    Location
    Valdosta, GA
    MS-Off Ver
    Office 2019
    Posts
    18

    Re: If blank then display blank

    ChemistB

    Thank you.

    It worked perfect.

    Exactly what I wanted.

    Once again, the Excel wizards have worked their magic.

    Nvable.

    I will mark as solved.

+ 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] Trying to display blank cells as blank, rather than 0% with INDEX and MATCH
    By davo3286 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2020, 07:11 AM
  2. [SOLVED] Need help making COUNTIFS formula display as blank if it's 'criteria cell' is blank
    By 27POP27 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2018, 07:38 AM
  3. Display blank cell if previous cell is blank in formula
    By Brent951 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-29-2016, 03:34 PM
  4. [SOLVED] Formula to display blank if 2 cells are blank
    By bdouglas1011 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2014, 08:47 AM
  5. 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
  6. Replies: 2
    Last Post: 08-23-2010, 06:28 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