Simple One
 

Hello I want to add column A and column B, but if the total is zero I do
not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is
obviously wrong thanks

Simple One
 

=IF(A1+B1=0,"",A1+B1)

"Wanna Learn" wrote:

Hello I want to add column A and column B, but if the total is zero I do
not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is
obviously wrong thanks

Simple One
 

contents of C2 will be the following, and display the sum of the
adjacent cells in column A with column B.

=if(A2*B2, A2+B2,"")

Not sure what you were doing adding up rows. A2 + A3 is row addition.

Wanna Learn wrote:

Hello I want to add column A and column B, but if the total is zero I do
not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is
obviously wrong thanks

Simple One
 

The OP asked for the zero not to show if the TOTAL is zero, not if the
PRODUCT is zero, so you could change that to
=if(A2+B2, A2+B2,"")
--
David Biddulph

"Bob I" wrote in message
...
contents of C2 will be the following, and display the sum of the adjacent
cells in column A with column B.

=if(A2*B2, A2+B2,"")

Not sure what you were doing adding up rows. A2 + A3 is row addition.

Wanna Learn wrote:

Hello I want to add column A and column B, but if the total is zero I
do not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but
it is obviously wrong thanks

Simple One
 

Thank you for the correction, I transposed the request.

David Biddulph wrote:

The OP asked for the zero not to show if the TOTAL is zero, not if the
PRODUCT is zero, so you could change that to
=if(A2+B2, A2+B2,"")