Formula To Return 0 Not Value?

[rockyw]

I have 2 formulas that return VALUE, can I have this return 0 instead? They also have a conditional format if that matters. The formulas are...
and

=AVERAGE(B22:E22)

How can I change these to return a 0 or black instead of VALUE? Thanks for ay help.

 

[Oeldere]

=iferror(AVERAGE(B22:E22),0)

 

[steve the fish]

=IFERROR(formula,0)

Or perhaps be better to sort out your errors?

 

[rockyw]

Thanks for the help, it's working. There is no error, just no data yet. Thanks