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