#DIV/O! error divided by zero

**Diesel13** · 01-21-2010, 10:21 PM

Hi, I found another problem with my pool spreadsheet.

In the Calculation worksheet, region P3:AU27 ;

Within that table, it would be nice to have the formula's filled for the entire table but as it stands, I have to drag the formula every time we play, I'd like to lock that page so I don't make a mistake in it. Because I get an #DIV/0! error that screws up all the results.

Is there a way to fill that table with the formula so I don't have to touch it and the results will be calculated properly?

The function of the said table is to give the players their true average in percentage. It calculates the amount of points they accumulated individually everyday they played, compares to the total possible points in that day and returns an average.

So to recapitulate, if I drag the formula's form " Calculations " " AI " to " AJ ", I'll get errors if there was no score entered in the Player DATA sheet. Any way to avoid this ?

BTW, I'm using excel 2007.

Thanks, Mike.

**NBVC** · 01-21-2010, 10:24 PM

I think basicallly the structure you need is along the lines of...

=IF(divisor cell="","",your_formula)

**Diesel13** · 01-21-2010, 10:30 PM

Something like this ?

Please Login or Register  to view this content.

entered in cell AJ3 ? and then dragged ?

does not work, probably doing it wrong, not that good at excel.

**NBVC** · 01-21-2010, 10:34 PM

Try

=IF(BW28l="","",BW3/BW28)

**Diesel13** · 01-21-2010, 10:37 PM

#NAME?

this is what I get

**NBVC** · 01-21-2010, 10:38 PM

Sorry...I've got fat fingers....

=IF(BW28="","",BW3/BW28)

**Diesel13** · 01-21-2010, 10:42 PM

How does this look ?

=IF(BW28="",BW3/BW28,"")

seems to work testing as we speak

**NBVC** · 01-21-2010, 10:45 PM

Shouldn't it be as I showed?: =IF(BW28="","",BW3/BW28)

This checks to see if BW28 is blank.. If it is, it will return a blank instead of an error. If it is not blank, then it will do the division.

Would there be zeroes in BW28 or blanks? if zeroes, the replace the "" with 0..

**Diesel13** · 01-21-2010, 10:46 PM

Well, that does not give me errors but it does not calculate either . . .

**Diesel13** · 01-21-2010, 10:49 PM

YES !!!!!!!!

You got it, works great, now, to re-do the entire table using this formula . . ..

ah well, beggers can't be choosers.

Thanks a lot, another problem solved.

Mike.