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