Comments on: Excel ISBLANK function to check if cell is empty or not

There are many situations when you need to check if a cell is empty or not. For instance, if cell is blank, then you might want to sum, count, copy a value from another cell, or do nothing. In these scenarios, ISBLANK is the right function to use. Continue reading →

Table of contents

Comments page 2. Total comments: 52

  1. I need formula to calculate number of days from today if column is blank and if not blank then calculate number of days from today from different cell.

    1. Hi,
      Try the following formula:

      =IF(ISBLANK(C1),DATEDIF(A1, TODAY(), "d"),DATEDIF(B1, TODAY(), "d"))

      You can learn more about DATEFIF function in Excel in this article on our blog.

  2. Hi --

    I've set up a search input using the SEARCH function that displays results from a table on a separate worksheet.

    For instance:

    Search term (user entered): "arbitration"

    table on separate worksheet:

    1 parties must agree to arbitration
    2 terms and conditions are binding
    3 arbitration is conducted in the USA

    When values are returned based on this search (using a fairly complex INDIRECT(MATCH(ADDRESS... formula, I get this:

    1 parties must...
    0 0
    3 arbitration is...

    Is there a way for me to pull in this data without having to display rows in which the search term doesn't appear? The table is very long, so I don't want to just have 100 rows where some are blank and others are populated. I want to return a list with no blanks. Any ideas?

    Thanks!

  3. I have a list of dates in Column A and data in column B. I am trying to return the last date in column A that has data before the first blank appears in column B. So in this example I need it to return 12/5/2020. Thanks!

    11/21/2020 10307
    11/28/2020 10181
    12/5/2020 10194
    12/12/2020
    12/19/2020

  4. I put in my work email not registered - this one has my registered contact for previous question. Thank you

  5. I would like to calculate a due date of 10 working days ONLY if the first column is not blank.
    Cell H132 is my first calculated date (given to employee). Column J132 would be the target date of 10 working days after only if H132 is blank.

    So, given that, =WORKDAY(H132,10) is fine. How do I incorporate to not count if H132 is blank?

    Previously, I was using "IF(H132="","",H132+10) which works fine. How do I incorporate the workday function? Thank you!

    1. Hello!
      If I got you right, the formula below will help you with your task:

      =IFERROR(IF(ISBLANK(H132),"",WORKDAY(H132,10)),"")

      I hope my advice will help you solve your task.

  6. I would like to calculate a due date of 10 working days ONLY if the first column is not blank.
    Cell H132 is my first calculated date (given to employee). Column J132 would be the target date of 10 working days after only if H132 is blank.

    So, given that, =WORKDAY(H132,10) is fine. How do I incorporate to not count if H132 is blank?

    I have tried both ISBLANK

    1. I tried this as well:
      =if(or(isblank(H199),"",workday(H199,10,holidays!A1:a11)))

      1. Can you cancel my comments/thread? I figured it out:

        =IF(ISBLANK(H67),"",WORKDAY(H67,10,Holidays!A1:A11))

        1. Thanks Earl ! You also solved my similar problem.

  7. I am trying to make a conditional formula that if cell A1 is blank, then I need cell B1 to be blank, but if cell A1 has a date that is today or older in the past, the B1 cell is to be highlighted and have a certain text color, but if the date in cell A1 is a future date (tomorrow and forward), I need cell B1 to be a different color and font. I am basically using it to alert me to things that are due to be worked because time is up. I want it to stick out that I need to work something because time is up today.

    Thank you for your time!!!
    Paula

  8. Your presentations are superb. I wrote a similar If not blank then sum formula. However it didn't work and I knew the problem was with the logical test. I got to your page and saw that it should simply be written as while I wrote mine as "" to test for empty. I have made the corrections and it worked! However I am a little confused as to how the formula could work without testing for any specific condition. I will truly appreciate your explanations. Thanks

  9. thank you for free service you offer
    I really appreciate your effort
    thank u very much

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)