Google-sheets – How to check if a cell is empty if it contains a reference value

google sheets

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?

Best Answer

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

Related Solutions

Google Sheets Formulas – Using the ISBLANK() Function

You can check whether a cell is empty or not by using the following formula:

=if(C2="";"The cell is empty";"The cell is not empty")

Google-sheets – How to check if value is in range of cells

You could use COUNTIF.

For example:

=COUNTIF(G:G,6) > 0

if you want to find the number 6 in the range G:G, and/or

=COUNTIF(A1:B7,"d") > 0

if you want to find d in the first seven rows of the first two columns.

COUNTIF will return the number of instances in its given range that are equal to its given value. It can also do a bit more complex conditioning (e.g all values higher than 6, or containing the letter A); see the docs for more info.

Best Answer

Related Solutions

Google Sheets Formulas – Using the ISBLANK() Function

Google-sheets – How to check if value is in range of cells

Related Topic