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