Cell blank

[Pat]

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)

 

[Sean Timmons]

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

 

[Joe@Phoenix]

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.

 

[JoeU2004]

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))

 

[Jim]

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!