View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Meenie Meenie is offline
external usenet poster
 
Posts: 192
Default 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