Google spreadsheets ISEMPTY() formula function

Question

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 cell seems to be empty without any value.

Answer 1

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

Answer 2

I can use function

=IF(COUNTBLANK(cell:cell)=1;"Blank cell";"Not blank")

that will be one only of the cell is empty.