blank cell not a "0"

  • Thread starter Thread starter Gary F
  • Start date Start date
G

Gary F

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

Use:

=IF(Sheet1!A1="",""Sheet1!A1)

In some cases you might also use:

Tools > Options > View
Remove check from "Zero values"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thank You Norman
-----Original Message-----
Hi Gary!

Use:

=IF(Sheet1!A1="",""Sheet1!A1)

In some cases you might also use:

Tools > Options > View
Remove check from "Zero values"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
n
Click to expand...
 
Back
Top