read cell onlyif value is notblank other wise error code example Example: excel check if cell not empty IF(A1<>"","Not empty","Empty")