google sheets if cell is not empty code example

Example 1: excel check if cell not empty

IF(A1<>"","Not empty","Empty")

Example 2: google sheets count cells if not blank

# Basic syntax:
=COUNTA(range)

# Example usage:
=COUNTA(A1:B26)

Example 3: google script check if cell is empty

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var range = sheet.getRange("B2:D4");

Logger.log(range.isBlank());