return empty cells with SUM and IF

[Bilingual]

Hi i have a formula which returns a value if the cell refered to is empty/null, it is here:

IF(a1="";"";a1), it works fine.

However i have a problem, if i want to return an empty cell when two cells are multiplied such as:

=IF(SUM(B117;B11)="";"";SUM(B117+B11))

Excel returns zero instead of null/empty cell, despite both cells are with no value besides zero and i need it to return empty cells, does anybody know how?

 

[Mike Blackman]

Hi,

In your logical test don't check for blanks check for zero's...

=IF(SUM(B117;B11)=0;"";SUM(B117+B11))

 

[Bilingual]

Thanks a lot, now it works