If null, make cell blank
 

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!

If null, make cell blank
 

Instead of using this kind of link formula: =Sheet1!A1
you could try something like this:
=IF(Sheet1!A1="","",Sheet1!A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nicole L." wrote:
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!