So why did you answer here when you could have sent him an email?
His posted question doesn't say anything about positive so according to
yourself in previous postings it is better to answer with regards the OP and
assume that anything is possible. I seem to recall a certain question when
someone posted an answer assuming positive numbers and you came down on it
although in that case it was much more likely that the OP had only positive
values?


--

Regards,

Peo Sjoblom

"Dave Thomas" wrote in message
. net...
I have his spreadsheet

"Sandy Mann" wrote in message
...
Are you positive? Nowhere in Dan the Man posts do I see him saying that
the data will *always* be positive.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave Thomas" wrote in message
et...
The data is positive

"Peo Sjoblom" wrote in message
...
What if the sum is zero in C4:C500 due to negative and positive values?
Since the OP said "until data begins appearing in the C4:C500" it would
be better to test C4:C500 for blank cells.

--

Regards,

Peo Sjoblom

"Dave Thomas" wrote in message
. net...
Here's one way:

=IF(SUM(C4:C500)<0,AVERAGE(C4:C500),"")
=IF(AO19<0,SUM(AL4:AL18)/AO19,"")
=IF(AO19<0,AL4/AO19,"")

"Dan the Man" wrote in message
...
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