IF Blank

  • Thread starter Thread starter matthew
  • Start date Start date
M

matthew

I have 2 worksheets and I have a cell from one worksheet
linked to a cell in the other worksheet. what formula can
i use to return nothing (instead of a 0) if the cell
which i am linked to is blank?
 
matthew,

IF(yourlinkformula=0,"",yourlinkformula)
or
Tools/Options/General uncheck "Zero Values"

John
 
Depends what you mean by 'linked'.

If it's just a straight forward reference eg '=sheet2!B2' then this is
abnormal behaviour. It may be that your source *is* a zero but is formatted
as blank.

If you're using VLOOKUP then you need something like
'=IF(ISBLANK(vlookupformula),"",vlookupformula)'

Also look at Tools, Options, View, 'Zero Values' but that may have further
reaching effects than you would like.

HTH

Marc
 
Just in case the original cell contained 0, I think I'd use:

=if(yourlinkformula="","",yourlinkformula)

For example:

=if(sheet2!a1="","",sheet2!a1)
 
Back
Top