Hi,

While the array formula will remain as is, you can use conditinal formatting
to hide the error value. In the cell which has the array formula, go to
conditional formatting in the Format menu and in the drop down menu select -
"Formula is". In the other box, type - =iserror(cell reference)


Now click on the format tab and in Font colour, select white.

Now click on OK and OK again.

This should hide error values

Regards,

"Richard Buttrey" wrote:

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
__________________________