blank cell not a "0"

[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".

 

[Norman Harker]

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.

 

[Gary Fitz]

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