Can divide by zero or infinity during the calculation be taken as zero?

I am calculating S1=log10(1/A1) and sum all the Si where in some cases I get A=0 which leads to inf, making the final summation a problem. I used IFERROR command in MS Excel to avaoid 1/0 and assign it any other value I want as I can assign it zero to avoid porblem in summation. Kindly help How can I set S1 to zero if its an infinity.

Thanks in advance for the help.

Answer 1

[Cris LaPierre]

You could use the isinf function.

S1(isinf(S1)) = 0;

[Atique Khan]

Thanks a lot