Ignore or display blank for #DIV/0!

[jgray]

Hi - I am working on a sheet where I need to ignore, or leave blank, cells where #DIV/0! appears. I have tried several different equations including the ifiserror, however, because the cell which is displaying the #DIV/0! is already an if formula, excel is reminding me that I now have too many formulas. Here is the formula that is yielding #DIV/0!, (which it needs to because this is a template workbook), which I need to ignore:

=STDEVP(IF(DZ7:DZ37 = 0,"",DZ7:DZ37))

Thanks! Jacob

[zbor]

Try this (only for XL 2007)

=IFERROR(STDEVP(DZ7:DZ37), "")