Zero cell

When doing the sum of two empty cells. What is the formula to show "0" or empty and not the usual #DIV/0!.

Thanks.

Misterg

Hi,

If your summing two blanks cells it will return Zero.

If your dividing two cells it will return #DIV/0!.

Say the cells you are doing are A1 and B1 then enter the below formula in C1

=IF(ISERROR(A1/B1),0,A1/B1)

I checked to see if a error and returns 0 if true or A1/B1 if false.

VBA Noob