When "IF" gives result of zero

  • Thread starter Thread starter drus
  • Start date Start date
D

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?
 
Try this:-

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

I think that gives you what you want.

If you agree please hit Yes.

Thanks.
 
Back
Top