Google sheets average formula
In Google Sheets there are two ways of having an empty cell, one way is by defining an empty string "" and another way is by having nothing in that cell. To check that a cell meets these criteria of being “empty” we use the ISBLANK function, like so: A. B. 1. Yes empty. =IF(ISBLANK(A1),"Yes empty","No not empty") 2. =IF(TRUE,"",).