Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simplifying array formula which evaluates as error.
Hi,
I have the array formula see below {=SUM((kpi_Code=$C11&L$15)*(kpi_CD0)*(kpi_AFD0)* (kpi_CD))*100} which is the divisor element within a larger array formula. When this subset divisor element evaluates to zero, obviously the cell returns the #Div/0! result. I know I could wrap the whole formula in an If Iserror to get round this, i.e. If(iserror(large_formula),"",(large_formula) but this makes the whole formula - well much larger. Is there a more elegant way of arranging this in order to keep the whole formula as small as possible? TIA __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP !!! I have a ARRAY Formula HELP !!! | Excel Discussion (Misc queries) | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
Formula error... | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) |