and frequently leads to confusion.

Amen, brother!


--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
I'm glad that helped, thanks for the feedback.

Empty is just that when referring to a cell i.e it contains nothing,

A formula that returns nothing as in the example I gave you by definition
isn't empty and correctly is referred to a Null string i.e a string that
has
no length.

Blank is a term i prefer not to use for cells because FWIW in my view it
adds nothing to either of the definitions noted above and frequently leads
to
confusion.


Mike

"KRK" wrote:

Hello

Thanks yes this works, is the null string the same as blank and empty ?

K


"Mike H" wrote in message
...
I'm not sure I fully understand but does this point you in the correct
direction?

=IF(A1=1,"",A1)

This will return the contents of A1 if it doesn't equal 1 but the cell
isn't
empty, it contains a Null string

Mike

"KRK" wrote:

Hello,

I have a cell which ontains an IF function. I want the cell to remain
empty
unless the IF returns a certain value. I know how to use IF, but how
do I
make a cell 'empty' ?

Thanks

K