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[TABLE="width: 188"]
<tbody>[TR]
[TD="colspan: 2"]#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.[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.