Cell blank
 

the cell A3 show 0 when their is no values in A1& A2 can it display a blank
if their is no values but a "0" if a "0" is entered in A1 or A2
=SUM(A1:A2)

Cell blank
 

=if(OR(A1="",A2=""),"",SUM(A1:A2))

"Pat" wrote:

the cell A3 show 0 when their is no values in A1& A2 can it display a blank
if their is no values but a "0" if a "0" is entered in A1 or A2
=SUM(A1:A2)

Cell blank
 

in the excel options - advanced
there is an option to "Show a zero in cells that have zero value"
uncheck that to display nothing

i hope this helps.

"Pat" wrote:

the cell A3 show 0 when their is no values in A1& A2 can it display a blank
if their is no values but a "0" if a "0" is entered in A1 or A2
=SUM(A1:A2)

Cell blank
 

"Pat" wrote:
the cell A3 show 0 when their is no values in A1& A2 can it display
a blank if their is no values but a "0" if a "0" is entered in A1 or A2
=SUM(A1:A2)

=if(A1&A2 = "", "", SUM(A1:A2))

Cell blank
 

Thank you! Unchecking that box took care of the issue I was having
referencing a column of dates in another workbook. When there is no date, it
was displaying 1/0/00 because the cell value was blank, technically "zero".
Unchecking it did the trick!

"Joe@Phoenix" wrote:

in the excel options - advanced
there is an option to "Show a zero in cells that have zero value"
uncheck that to display nothing

i hope this helps.

"Pat" wrote:

the cell A3 show 0 when their is no values in A1& A2 can it display a blank
if their is no values but a "0" if a "0" is entered in A1 or A2
=SUM(A1:A2)