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
|