HELP! Need help with function!

  • Thread starter Thread starter andyc18
  • Start date Start date
A

andyc18

I am having a hard time knowing what to use when finding an average in
column of cells where #DIV/0! is showing.

The #value is showing when I have the formula
=IF(E6=0, "0",E6/F6)

E6 is =IF(Jan!D32=0, "0", Jan!D32)

When the value of E6 is 0 then #value is returned and I can not do a
accurate average.

Can someone help please! Is there a way to do an average that doesn'
count a cell if it has a #VALUE and/or #DIV/0!???
 
Hi

Better is to avoid error messages. P.e. instead =IF(E6=0, "0",E6/F6) use:
=IF(OR(E6="",F6="",F6=0),"",E6/F6)

Now you can calculate the average without problems.
Btw. The condition E6=0 in your formula is abundant, because 0 divided by
any non-zero value always returns 0. And for what cause are you returning 0
as string ("0")?
 
Back
Top