software

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 whe

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
quot;quot; in the middle of the formula.

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

Where have I gone wrong?

THANK YOU!!! --
navychef
------------------------------------------------------------------------
navychef's Profile: www.excelforum.com/member.php...oamp;userid=29457
View this thread: www.excelforum.com/showthread...hreadid=494267=IF(ISERROR(AVERAGE(G5,L5,Q5)),quot;quot;,AVERAGE(G5,L5,Q5 ))

--
Kind regards,

Niek Ottenquot;navychefquot; gt; wrote in
message ...
gt;
gt; Hello. I'm stuck once again, and I've come to the greatest place on the
gt; web to seek help! I've learned so much from asking questions and also
gt; reading what others are learning to do.
gt;
gt; I'm working on a sheet whe
gt;
gt; G5 is a percentage (D5-E5)/F5
gt; L5 is a percentage (I5-J5)/K5
gt; Q5 is a percentage (N5-O5)/P5
gt;
gt; When I average G5, L5, Q5, (to place results in R5), I get the #DIV/0
gt; error until I get a figure into either G, L, or Q. I have been working
gt; with =IF(ISERROR to try and hide it, but I keep getting stuck with the
gt; quot;quot; in the middle of the formula.
gt;
gt; What I was writing is:
gt; =IF(ISERROR(AVERAGE(G5,L5,Q5),quot;quot;,AVERAGE(G5,L5,Q5)
gt;
gt; Where have I gone wrong?
gt;
gt; THANK YOU!!!
gt;
gt;
gt; --
gt; navychef
gt; ------------------------------------------------------------------------
gt; navychef's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29457
gt; View this thread: www.excelforum.com/showthread...hreadid=494267
gt;

BINGO!

Thank you, Niek!--
navychef
------------------------------------------------------------------------
navychef's Profile: www.excelforum.com/member.php...oamp;userid=29457
View this thread: www.excelforum.com/showthread...hreadid=494267Another way:

=IF(SUM(G5,L5,Q5),AVERAGE(G5,L5,Q5),quot;quot;)

Biff

quot;navychefquot; gt; wrote in
message ...
gt;
gt; Hello. I'm stuck once again, and I've come to the greatest place on the
gt; web to seek help! I've learned so much from asking questions and also
gt; reading what others are learning to do.
gt;
gt; I'm working on a sheet whe
gt;
gt; G5 is a percentage (D5-E5)/F5
gt; L5 is a percentage (I5-J5)/K5
gt; Q5 is a percentage (N5-O5)/P5
gt;
gt; When I average G5, L5, Q5, (to place results in R5), I get the #DIV/0
gt; error until I get a figure into either G, L, or Q. I have been working
gt; with =IF(ISERROR to try and hide it, but I keep getting stuck with the
gt; quot;quot; in the middle of the formula.
gt;
gt; What I was writing is:
gt; =IF(ISERROR(AVERAGE(G5,L5,Q5),quot;quot;,AVERAGE(G5,L5,Q5)
gt;
gt; Where have I gone wrong?
gt;
gt; THANK YOU!!!
gt;
gt;
gt; --
gt; navychef
gt; ------------------------------------------------------------------------
gt; navychef's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29457
gt; View this thread: www.excelforum.com/showthread...hreadid=494267
gt;
quot;Biffquot; gt; wrote...
gt;Another way:
gt;
gt;=IF(SUM(G5,L5,Q5),AVERAGE(G5,L5,Q5),quot;quot;)
....

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

Never do more work than necessary. Replace SUM with COUNT.
gt;Why should the average of -2, 5 and -3 display as quot;quot;?

Ouch!

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

That was my second choice.

Biff

quot;Harlan Grovequot; gt; wrote in message
...
gt; quot;Biffquot; gt; wrote...
gt;gt;Another way:
gt;gt;
gt;gt;=IF(SUM(G5,L5,Q5),AVERAGE(G5,L5,Q5),quot;quot;)
gt; ...
gt;
gt; Why should the average of -2, 5 and -3 display as quot;quot;?
gt;
gt; Never do more work than necessary. Replace SUM with COUNT.
gt;