The Excel Spreadsheet Excelclopedia
Printable ViewExcel ISBLANK Function
Syntax
=ISBLANK(reference)
Checks if a cell reference is blank
Returns TRUE or FALSE
Returns TRUE if the cell is blank
Examples
| A | B | C | D | E | F | G |
| 2 | Returned Values | |||||
| 3 | cell D3 is blank | =ISBLANK(D3) | TRUE | |||
| 4 | 1000 | =ISBLANK(D4) | FALSE | |||
| 5 | abd | =ISBLANK(D5) | FALSE | |||
| 6 | 0 | =ISBLANK(D6) | FALSE | |||
| 7 | 12 | 0 | =+B7/C7 | =ISBLANK(D7) | FALSE | |
| 8 | b8 | =ISBLANK(INDIRECT(C8)) | TRUE |
Categories: IS Functions