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.
Best Answer