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

On Wed, 8 Nov 2006 15:23:01 -0800, Don wrote:

Hi all,

Is there a 'IF' statement describing ..... IF 'a cell is empty' THEN ......

Many thx,

Don-