My Final #DIV/0! that I'd like to say Goodbye to!
Once again Dave you saved the day. I appreciate all of your help with my
spread sheet and helping me to get rid of those division errors. You are
great. Have an awesome weekend!
Dan
"Dave Thomas" wrote:
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
|