Re: Suppress #DIV/0! Alternatives
I had an answer all worked out then realized that it will only work on Office 2007 due to the nesting limitations in Office 2003. I will post the formula anyhow and perhaps you or someone else can figure out how to get around the nesting problem.
If you want it to show as a blank, I used a simple IF statement in front of the ISERROR, once the ISERROR results TRUE, then it results as a "BLANK", you can replace what is in quotes to be "0", or whatever value you want
=IF(ISERROR(SUM(IF(D3:D5="Y",IF(F3:F5="",IF(E3:E5="",C3:C5)/SUM(IF(D3:D5="Y",IF(F3:F5="",IF(E3:E5="",B3:B5)))))))),"0")
This formula gives a value of " ", A blank cell, this is the formula that is nested too many times.
If you want it to show as a true only, this just asks the formula if there is an error present in the cell TRUE =ISERROR(SUM(IF(D3:D5="Y",IF(F3:F5="",IF(E3:E5="",C3:C5)/SUM(IF(D3:D5="Y",IF(F3:F5="",IF(E3:E5="",B3:B5))))))))
This formula gives a value of TRUE
LaTarsha Carr