Hide #div/0 Error When Averaging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

navychef - 16 Dec 2005 22:21 GMT

Hello. I'm stuck once again, and I've come to the greatest place on the
web to seek help! I've learned so much from asking questions and also
reading what others are learning to do.

I'm working on a sheet where:

G5 is a percentage (D5-E5)/F5
L5 is a percentage (I5-J5)/K5
Q5 is a percentage (N5-O5)/P5

When I average G5, L5, Q5, (to place results in R5), I get the #DIV/0
error until I get a figure into either G, L, or Q. I have been working
with =IF(ISERROR to try and hide it, but I keep getting stuck with the
"" in the middle of the formula.

What I was writing is:
=IF(ISERROR(AVERAGE(G5,L5,Q5),"",AVERAGE(G5,L5,Q5)

Where have I gone wrong? :confused:

THANK YOU!!! :)

Signature

navychef

Reply to this Message

Niek Otten - 16 Dec 2005 22:30 GMT

=IF(ISERROR(AVERAGE(G5,L5,Q5)),"",AVERAGE(G5,L5,Q5))

Signature

Kind regards,

Niek Otten

> Hello. I'm stuck once again, and I've come to the greatest place on the
> web to seek help! I've learned so much from asking questions and also
[quoted text clipped - 17 lines]
>
> THANK YOU!!! :)

Reply to this Message

navychef - 16 Dec 2005 22:39 GMT

BINGO! :eek:

Thank you, Niek!

Signature

navychef

Reply to this Message

Biff - 16 Dec 2005 22:45 GMT

Another way:

=IF(SUM(G5,L5,Q5),AVERAGE(G5,L5,Q5),"")

Biff

> Hello. I'm stuck once again, and I've come to the greatest place on the
> web to seek help! I've learned so much from asking questions and also
[quoted text clipped - 17 lines]
>
> THANK YOU!!! :)

Reply to this Message

Harlan Grove - 17 Dec 2005 06:23 GMT

"Biff" <biffinpitt@comcast.net> wrote...

>Another way:
>
>=IF(SUM(G5,L5,Q5),AVERAGE(G5,L5,Q5),"")

...

Why should the average of -2, 5 and -3 display as ""?

Never do more work than necessary. Replace SUM with COUNT.

Reply to this Message

Biff - 17 Dec 2005 06:44 GMT

>Why should the average of -2, 5 and -3 display as ""?

Ouch!

>Never do more work than necessary. Replace SUM with COUNT.

That was my second choice.

Biff

> "Biff" <biffinpitt@comcast.net> wrote...
>>Another way:
[quoted text clipped - 5 lines]
>
> Never do more work than necessary. Replace SUM with COUNT.

Reply to this Message