View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Smith Bob Smith is offline
external usenet poster
 
Posts: 28
Default Hiding a #DIV/0! comment

Hi folks, within another workbook, I track game data for our team. I have a
few columns where games have yet to be played and am showing the following
above error message as there is no data in the columns. Formula I'm using
is - =ROUNDDOWN(AVERAGE(K40:K45),0) .

Any suggestions on modifications so that I don't show the error message,
other than just changing the font to white font?

TIA,

Bob