Hi there,

I have some cells with a formula such as;

=AVERAGEA(C12:C16)
=ROUND(C17/25,4)
=SUM(C17:G17)/100
=H17+H19
etc. etc.

Until a number is input into another cell which is included in one of the
formulas above the annoying #DIV/0! appears.

As soon as a number is input into a 'donor cell' included in one of the
calculations above then the #DIV/0! changes into its expected format.

Is there a way to hide the annoying #DIV/0! that is dotted all over the
spreadsheet while the 'donor' cell is empty before its result is known?

The sheet looks very untidy and gives the impression it is full of errors
while the #DIV/0! is displayed.

--
Thanks & regards,
-pp-