Data Cleaningbeginner
Check for empty cells with ISBLANK
=IF(ISBLANK(A2),"Missing","OK")
Google Sheets reference
ISBLANK in Google Sheets
Works in Google Sheets1 worked example
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full ISBLANK reference for Excel — including all worked examples, common errors, and FAQ.
ISBLANK Excel reference →