Cell blank

  • Thread starter Thread starter Pat
  • Start date Start date
P

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)
 
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 said:
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)
Click to expand...

=if(A1&A2 = "", "", SUM(A1:A2))
 
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!
 
Back
Top