Share this article:

What it does: The ISBLANK() Function returns a boolean result – whether or not the cell is blank.

Plain English: This formula let’s you know if the cell in question is blank. This is useful because if you’re dealing with hundreds or thousands of rows of data, you may need to handle blank values separately. What if 21 out of 365 days of the year show blank data?

  • Why are the cells blank?
  • Where did the error occur?

The ISBLANK() formula is often used in conjunction with an IF() formula to write conditional arguments.

Arguments: ISBLANK(cell)

  • Cell – the cell you want to check