need formula help fast please!!

M

Meenie

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
 
D

Don Guillett

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))
 
M

Meenie

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
 
P

Pete_UK

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
 
Top