+ Reply to Thread
Results 1 to 3 of 3

Leave cell blank if no data entered into cell

  1. #1
    Registered User
    Join Date
    08-27-2021
    Location
    Milford, CT
    MS-Off Ver
    Office 365
    Posts
    2

    Leave cell blank if no data entered into cell

    Hello,
    I have a workbook i am trying to repair after it was deleted by accident. It is an inspection sheet that will return Pass or Fail if measured value is between high and low limit. I have the function working to correctly populate pass or fail in the results but when I copy the formula down the column it still shows the result. Can someone please look at this and let me know how to leave the results cell blank if no data is in the "Measured dimension" column.
    Thanks in advance for any help. It wouldn't let me attach the file but here is a screenshot.

    Attachment 745641
    Attached Images Attached Images

  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,216

    Re: Leave cell blank if no data entered into cell

    =IFf(E6="","",IF(AND(....))

  3. #3
    Registered User
    Join Date
    08-27-2021
    Location
    Milford, CT
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Leave cell blank if no data entered into cell

    Thank you!

+ 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] Calculate future date, but leave cell blank if no date is entered
    By kyber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2021, 03:28 PM
  2. [SOLVED] How to leave leave cell blank if all cells added together = 0
    By jmitch26 in forum Excel General
    Replies: 3
    Last Post: 07-30-2019, 11:00 PM
  3. [SOLVED] Leave Cell Blank until data is entered in a certain cell
    By Fredbugatti in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2018, 01:09 PM
  4. [SOLVED] Leave cell blank until data is posted
    By Philangr8 in forum Excel General
    Replies: 14
    Last Post: 05-27-2016, 08:12 PM
  5. [SOLVED] Leave cell blank unless data entered
    By ExcelDummy77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2015, 11:05 AM
  6. Leave Cell Blank if it has NO data (but the cell Contains Formula)
    By LadyB21 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-07-2013, 09:21 PM
  7. Leave cell blank if no data
    By Millerk in forum Excel General
    Replies: 3
    Last Post: 03-01-2006, 11:00 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