View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
E-Coder E-Coder is offline
external usenet poster
 
Posts: 25
Default Hiding a #DIV/0! comment

You can trap the error and have Excel show nothing instead...

=IF(ISERROR(ROUNDDOWN(AVERAGE(K40:K45),0)),"",ROUN DDOWN(AVERAGE(K40:K45),0))

"Bob Smith" wrote:

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