Assistance required with #DIV/0!

[Rudi3010]

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.

[#2 · Accepted solution]

@Rudi3010 

Use

=IFERROR(AVERAGE(E24:L24),0)

or

=IFERROR(AVERAGE(E24:L24),"")

[#3]

@Hans Vogelaar Thanks it worked.