When "IF" gives result of zero

[drus]

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?

 

[Bob Phillips]

It works the same in 2007. What are you getting?

HTH

Bob

 

[trip_to_tokyo]

Try this:-

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

I think that gives you what you want.

If you agree please hit Yes.

Thanks.