How to show nothing in the cell with a formula

[anthonyls1]

I have an average formula I use in Excel which is =AVERAGE(R20:R22) and when the cells are blank I get this

#DIV/0! How do I show the #DIV/0 blank if there are no values from R20-R22? Thank you in advance for any help.

<tbody>
</tbody>

 

[JoeMo]

Try:
=IFERROR(AVERAGE(R20:R22),"")

 

[anthonyls1]

Thank you Mr.JoeMo. That is perfect! Thank you for a very quick response as well.

Try:
=IFERROR(AVERAGE(R20:R22),"")

 

[JoeMo]

You are welcome - thanks for the reply.