In the context of a formula like =IF(A1="","",A1)

It means if A1 is empty or blank then return a blank.

A1 may not necessarily be empty.

It could have a formula which evaluates to "" so the above formula would see
that as blank.


Gord Dibben MS Excel MVP

On Tue, 7 Oct 2008 10:29:09 -0700, chris
wrote:

please help