0

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?

Improve this question
1
  • 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.
    – marikamitsos
    Commented Feb 5, 2021 at 0:56

1 Answer 1

Reset to default
0

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

Improve this answer
2
  • 1
    Returning 0 or 1 is not what you asked for in your post. Even so, using IF still works
    – marikamitsos
    Commented 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.
    – Hassan Almaateeq
    Commented Feb 5, 2021 at 4:56

Your Answer

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

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