Do not use " " in your formulas. That creates a space.

Use "" to return nothing as a condition..

e.g. =IF(A1="","",A1)

Means if A1 is empty, show nothing.....if something in A1 show that.

=IF(A1=" ", " ",A1) is entirely different

Means if A1 contains a space, return a space.

Not good.


Gord Dibben MS Excel MVP

On Fri, 5 Mar 2010 20:34:49 -0800, Jane
wrote:

When working in excel and doing my labs, I am often told to use " " in my
formulas but I don't know what " " stand for and the ! is also used, can
someone explain to me what " " and ! mean?