Formula function for ignoring cells/results equal to 0 (zero) ?

K

Keith Clark

Assume I want to setup a formula for a cell which should calculate the result from several other cells
similar to

C1=K5/k6 + U8/U9 + M12/M13

As you can see if the value of the cells K6 or U9 or M13 are zero there is a division by zero
and the calculation crashes. In this case the terms should be ignored.

What I need now is a precalculation-and-ignore-instruction which excludes the terms similar to

C1=ignoreiftrue(K6=0,K5/k6) + ignoreiftrue(U9=0,U8/U9) + ignoreiftrue(M13=0,M12/M13)

In more general form the function

ignoreiftrue(<condition>,<expression>)

should evaluate at first the condition and if it is NOT true uses the expression(=function) as usual.

Is there such a function in Excel?

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check if any value in a range is equal to 0 4
Substituting zero values in blank cells 5
Concatenate many cells without zero's 9
AVERAGE IF formula and not equal to ZERO 2
Need help with formula to average numbers while ignoring "0" value 1
Ignoring zero cells in IF statements 5
TRANSPOSE results in zero values for blank cells 2
TRANSPOSE results in zero values for blank cells 4

Top