Google Sheets Formulas – Using the ISBLANK() Function

formulasgoogle sheets

Is there any way I can check whether a cell is empty?

There is a function ISBLANK() but it returns false when there's a formula in a cell even thought the formula doesn't return anything (or an empty string).

I would like it to return true when the formula doesn't return anything as well. So the cell seems to be empty without any value.

Best Answer

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")

Related Solutions

Google Sheets – ISBLANK Function Returns True for Nonempty Cells

The isblank function is intended for use with an individual cell; its behavior when applied to a range is not documented as far as I know. In your case, isblank($B:$B) returns True if it's placed in a row where B column is empty.

Use counta(...)>0 instead, like this:

=IF(COUNTA(Sheet1!$B:$B)*COUNTA(Sheet1!$C:$C)=0, 0, SUMPRODUCT(Sheet1!$A:$A=F2, Sheet1!$B:$B=Sheet1!$C:$C))

Google Sheets – How to Nest a Function Within a Logical Statement

=IF(RIGHT(E23,2)>RIGHT(D23,2),RIGHT(E23,2)-RIGHT(D23,2),"NO")

"=" not required inside if statement.

Best Answer

Related Solutions

Google Sheets – ISBLANK Function Returns True for Nonempty Cells

Google Sheets – How to Nest a Function Within a Logical Statement

Related Topic