Get rid of #DIV/0! without repeating denominator?
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Go Bucks!!!" wrote in message
...
Hi T,
Its just a simple average formula. I wanted to perform the same work as
the
IF(denominator = 0,""), but I didnt want to have to write out the whole
denominator formula. This is exactly what I was looking for. Zero or
Blank
works great.
Thanks!!!
"T. Valko" wrote:
I you're using Excel 2007 it's pretty easy:
=IFERROR(your_formula(...),"")
If the formula does not return #DIV/0! what is the typical range of
results
you expect? Would a result of 0 be OK instead of blank?
--
Biff
Microsoft Excel MVP
"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,
|