Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Formula function for ignoring cells/results equal to 0 (zero) ?
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Formula function for ignoring cells/results equal to 0 (zero) ?
=IF(ISERROR(K5/K6),0,K5/K6) + .... + ...
If this post helps click Yes --------------- Jacob Skaria "Keith Clark" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula function for ignoring cells/results equal to 0 (zero) ? | Excel Discussion (Misc queries) | |||
Ignoring formula results of #N/A | Excel Worksheet Functions | |||
Ignoring formula results of #N/A | Excel Worksheet Functions | |||
Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
Chart ignoring formulas but only plotting formula results | Charts and Charting in Excel |