IF function to make a cell blank

[Rnye14]

Thanks before hand for any help.

This is what I am trying to accomplish...

Column A sometimes has a numerical value sometimes not

Column B sometimes has a numerical value sometimes not

Column C has a formula in each row that adds any values that may be in either row of column A or B

My problem is the cells in column C when A and B are blank, show zero. I would like to use a formula to show all cells in column C that are zero show as being blank.

Thanks, very old newbie

[vlady]

=IF(COUNT(A17:B17)<1,"",A17+B17)
or
=IF(AND(A17="",B17=""),"",A17+B17)
or
=IF(MAX(A17:B17)=0,"",A17+B17)

[duanzhuanming]

Hi,
Another way for reference.no need to use function.
you can format cells.

see attached file below.

[vlady]

or for the entire workbook without function or formatting the cells

File->
option->advanced
"display option for this worksheet"
uncheck -> show a zero in cell that have 0 value