IF Command

[kashifjillani]

Hello dear community,

I want to use (may be) IF command to perform following task

There are two cells I want to add, but if one of values in those cells is zero then I dont want to add at all. Just zero may appear as result.

e.g.

cell A1 value is 2
Cell B3 value is 4

then sum A1+B3 = 6

BUT IF:

cell A1 value is 0
Cell B3 value is 4

then sum A1+B3 = 0

 

[ben.burgess]

Welcome to the board.

Yes an 'if' command will do what you need here but you would also need an 'or'. type this into the formula bar:

=if(or(A1=0,B3=0),0,A1+B3)

This will pick up a zero (or blank) in either cell and make the result 0. Everything else it will add the two cells.

 

[kashifjillani]

Welcome to the board.

Yes an 'if' command will do what you need here but you would also need an 'or'. type this into the formula bar:

=if(or(A1=0,B3=0),0,A1+B3)

This will pick up a zero (or blank) in either cell and make the result 0. Everything else it will add the two cells.

Many thanks Ben Burgess

 

[Peter_SSs]

Other slight variations would be

=IF(A1*B3,A1+B3,0)
=(A1+B3)*(A1*B3<>0)