I want to check a cell of a dropdown list if empty using IFBLANK or IF(A4="","blank","not blank" but always returns false.. How can I overcome this to see if any value chosen or just empty string?

  • 1
    "I want to check a cell of a dropdown list if empty..." There is no such function as IFBLANK. However. Both IF and ISBLANK return correct results. Feb 5, 2021 at 0:56

1 Answer 1


I found countblank() to solve the problem to return either zero or 1.

  • 1
    Returning 0 or 1 is not what you asked for in your post. Even so, using IF still works Feb 5, 2021 at 0:59
  • Thanks. Yes ISBLANK what I mean in the question. The problem is that the cell that has a reference value like List of range, It returns FALSE weather it is empty or has a value. So making a conditional formatting based on that is not possible. If I have 0 or 1 then I can do conditional formatting. Feb 5, 2021 at 4:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.