The following cells on my spread sheet produce the #DIV/0! error under the
following circumstances, and I'd prefer the cells to remain "blank" until
data is input to produce the outcomes identified (which do work once data is
provided):

C3:

=AVERAGE(C4:C500)

Division error will occur, until data begins appearing in the C4:C500 range
cells.

AV4:

=SUM(AL4:AL18)/AO19

Division error will occur, until data appears in cell AO19

AQ4:

=AL4/AO19

Division error will occur, until data appears in cell AO19

Any suggestions would be greatly appreciated!

Dan