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.