If null, make cell blank

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!
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell 1
Help needed 0
Hide columns based on row values 2
If function across sheets prints value of cell 4
use month in cell date to sum all relevant cells 2
Source and Destination worksheet difference 5
I need a cell to be blank. 4

Top