Repeating entries without "0" if no entry

  • Thread starter Thread starter Gary Fitz
  • Start date Start date
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.
 
Back
Top