Check If cell is blank in Excel

December 25, 2019 - by mahmood

=IF(D5="","Open","Closed")

=IF(ISBLANK(D5),"Open","Closed")

References
https://exceljet.net/formula/if-cell-is-blank
https://exceljet.net/excel-functions/excel-isblank-function