If null, make cell blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a cell in a wksheet, it has a formula that pulls the value/words from
another worksheet cell. If the cell it's referencing is blank, Excel gives me
a "O" in the destination cell.

How do I make it give a blank if the referenced cell is empty?

Help!
 
Instead of using this kind of link formula: =Sheet1!A1
you could try something like this:
=IF(Sheet1!A1="","",Sheet1!A1)
 
Back
Top