Cell R7 uses =AVERAGE(B7:Q7)
but until values are populated in B7-Q7, the error #DIV/0! shows in R7.

Can you tell me how to hide this error so my sheet looks clean?

I found general answer online, but not sure how to implement it.... =IFERROR(B1/C1,"")

Thank you very much!