need formula help fast please!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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))
 
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
 
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
 
Hi Guys!

I have a similiar query, I want the average of values entered in a range, but if no values are entered then the figure to read zero.

However upon enterigng the formula as you put it I get err:508

I have typed and retyped the formula, and made sure I have the right amount of corresponding brackets.

Any help would be greatly appreciated! Thanks!
 
Back
Top