There are some instances which require a test for an empty or blank cell. To
test for this condition, you need to compare the cell in question with another
cell that you know will always be blank, such as in:
IF(D5=X255,'blank',G4-D5)
assuming that X255 is always empty.