"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?

That depends on the revision of Excel that you want to design for. Excel
2007 has an IFERROR function. Otherwise, I would compute the denominator in
a helper cell, which can be hidden.


----- original message -----

"Go Bucks!!!" wrote in message
...
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,