INVSUMINV

INVSUMINV —

INVSUMINV(x1,x2,...)

INVSUMINV sum calculates the inverse of the sum of inverses.

The primary use of this is for calculating equivalent resistance for parallel resistors or equivalent capacitance of a series of capacitors.

All arguments must be non-negative, or else a #VALUE! result is returned.
If any argument is zero, the result is zero.

INVSUMINV(2000,2000) equals 1000.