Mar 08 2022 04:33 AM
I'm using and formula =AVERAGE(E24:L24) which return error #DIV/0! if there is no value in the database.
How can I correct the error to show maybe 0 or no value until a value is provided.
View best response
Mar 08 2022 04:40 AM
@Rudi3010
Use
=IFERROR(AVERAGE(E24:L24),0)
or
=IFERROR(AVERAGE(E24:L24),"")
Mar 08 2022 05:55 AM
@Hans Vogelaar Thanks it worked.
