=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
Daily Notes of a Programmer
=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