Get rid of #DIV/0! without repeating denominator?
Is the cause of the error #DIV/0 always caused by the same cell of column?
As a suggestion, you could preceed your formula with something like
=IF(D16=0,"",your formula) or =IF(SUM(C:C)=0,"",your formula)
"Go Bucks!!!" wrote:
I have some very long denominator formulas and these formulas are repeated
many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT
repeating the denominator?
=IF((denominator formula)=0,"",(numerator formula/denominator formula).
One of my actual formulas broken down is...
=IF
DENOMINATOR...
(SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM
LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0))
=0,"",
NUMERATOR...
(SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM
LIME")*('Call Activity'!$Q:$Q=1))
/
DENOMINATOR...
(SUMPRODUCT(('Call Activity'!$E:$E=$D16)*('Call Activity'!$C:$C="CHEM
LIME")*(ISNUMBER(MATCH('Call Activity'!$Q:$Q,{0,1},0)))))))
Thanks,
|