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.
Mar 08 2022 04:40 AM
SolutionMar 08 2022 04:40 AM
SolutionUse
=IFERROR(AVERAGE(E24:L24),0)
or
=IFERROR(AVERAGE(E24:L24),"")