Hi all, Is there a 'IF' statement describing ..... IF 'a cell is empty' THEN ...... Many thx, Don-
D Don Nov 8, 2006 #1 Hi all, Is there a 'IF' statement describing ..... IF 'a cell is empty' THEN ...... Many thx, Don-
G Gord Dibben Nov 8, 2006 #2 Don In any cell enter =IF(E10="","no value",E10) Note: there could be a formula in E10 that returns "" if a condition is not met, so E10 is not really empty but it will return as True. e.g. In E10 is =IF(A1=123,"OK","") Gord Dibben MS Excel MVP
Don In any cell enter =IF(E10="","no value",E10) Note: there could be a formula in E10 that returns "" if a condition is not met, so E10 is not really empty but it will return as True. e.g. In E10 is =IF(A1=123,"OK","") Gord Dibben MS Excel MVP
