need formula help fast please!!
 

I have a spreadsheet that gives an average percentage number ( =average(b5:G5)
but if nothing is entered I want it to show 0.00%
How to I make it show that??
Thanks!!!
Meenie

need formula help fast please!!
 

I assume you mean B5:G5 are empty?

=IF( ISERROR(AVERAGE(B5:G5)),0,AVERAGE(B5:G5))

"Meenie" wrote:

I have a spreadsheet that gives an average percentage number ( =average(b5:G5)
but if nothing is entered I want it to show 0.00%
How to I make it show that??
Thanks!!!
Meenie

need formula help fast please!!
 

try this idea. And, in the future, please remember that "fast please" will
turn some off to your request. Also, please state the gist of your problem
in the subject line such as, "Average formula error"

=IF(ISERR(AVERAGE(P5:P10)),"",AVERAGE(P5:P10))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Meenie" wrote in message
...
I have a spreadsheet that gives an average percentage number (
=average(b5:G5)
but if nothing is entered I want it to show 0.00%
How to I make it show that??
Thanks!!!
Meenie

need formula help fast please!!
 

Thank you so much, guys.
I finally figured out a formula that works although your's is probably much
more sophisticated than mine
I used: =IF(COUNTA(C3:G3)=0,"0.00%",AVERAGE(C3:G3))
Does that look ok? It seems to work, lol :)
Thanks, Meenie

"Meenie" wrote:

I have a spreadsheet that gives an average percentage number ( =average(b5:G5)
but if nothing is entered I want it to show 0.00%
How to I make it show that??
Thanks!!!
Meenie

need formula help fast please!!
 

You are returning 0.00% as a text value - this might cause some
problems elsewhere in the sheet if you intend to do some arithmetic
with it.

Hope this helps.

Pete

On Jul 26, 4:00 pm, Meenie wrote:
Thank you so much, guys.
I finally figured out a formula that works although your's is probably much
more sophisticated than mine
I used: =IF(COUNTA(C3:G3)=0,"0.00%",AVERAGE(C3:G3))
Does that look ok? It seems to work, lol :)
Thanks, Meenie



"Meenie" wrote:
I have a spreadsheet that gives an average percentage number ( =average(b5:G5)
but if nothing is entered I want it to show 0.00%
How to I make it show that??
Thanks!!!
Meenie- Hide quoted text -

- Show quoted text -