Try this:-

=IF(A1="","",B1)

I think that gives you what you want.

If you agree please hit Yes.

Thanks.



"drus" wrote:

In Excel 2000 on a UK keyboard, """" will check for, or leave, a cell blank.
Having used the "IF" function I want to leave the the result cell displaying
a blank . How can I get the same result with Excel 2007?