Repeating entries without "0" if no entry

G

Gary Fitz

How does one get around a "0" appearing in cells on
multiple sheets when "=+Sheet1!A1" is present and there is
no entry made. In other words Would prefer a blank cell
not a "0"

in sheet2, cell a1 enter "=+Sheet1!A1" w/o quotes
This will give you whatever is entered in sheet1, cell 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

Help with Conditional Format Formula 6
specific data 1
how do I create a nonadjacent series for autofill to go by? 3
Code to format cells on several worksheets 2
Match Copy/Paste Macro almost there 0
blank cell not a "0" 2
=Sheet1!A1 - with a blank entry!!! 2
Returning values listed under multiple conditions 6

Top