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
Bookmarks