If Error Formula for averages

Katye Reed

Hello,

Is there a way to use IF Error for an average? So if there is no data yet, it displays zero instead of the DividebyZero error?

Thanks for the assistance!

L_123

=iferror(avg(A1:A20),0)

L_123

=IFERROR(AVG([Time to Implement]:[Time to Implement]), 0)

parenthesis in wrong location

L_123

=iferror(avg(A1:A20),0)

Katye Reed

Thanks, but I am still receiving an incorrect argument set error. =IFERROR(AVG([Time to Implement]:[Time to Implement], 0))

L_123

=IFERROR(AVG([Time to Implement]:[Time to Implement]), 0)

parenthesis in wrong location

Katye Reed

Thanks!

Works like a charm now.

L_123

Glad I could help :)