Display 0, Not #DIV=0!

[GwdBrian]

I am putting together baseball statistics for our local American Legion baseball team. I put in hits and at-bats, then used a simple formula to calculate batting average. The problem is that for some of the players there are no at-bats. The cell for batting average displays an error when it tries to divide by 0. How can I get the cell to display "0.000" instead of the error when a player has no at-bats? Thanks in advance for any help.

[Søren Larsen]

Try:

=IFERROR("your formula here",0)

[GwdBrian]

That worked perfect! Thanks so much!

[Søren Larsen]

You're welcome. Don't forget to mark your thread as solved...

[MannyLNJ]

Try:

=IFERROR("your formula here",0)

I didn't know about =IFERROR I've been using the kludge of doing the calculations into one cell, then I hide the column. Then using an =IF that detects if talus of the cell is > 0 if it's not it puts "" in the display otherwise it displaces the value of the cell

[FDibbins]

@Manny iferror only works on 2007. not 2003, sorry

[icestationzbra]

I didn't know about =IFERROR I've been using the kludge of doing the calculations into one cell, then I hide the column. Then using an =IF that detects if talus of the cell is > 0 if it's not it puts "" in the display otherwise it displaces the value of the cell

if you want to experiment, try ISERROR (available in 2003) in conjunction with Circular Referencing. if your data set is not large, performance would not be affected drastically and you would be able to use shorter formulae and get rid of some helper columns (if that is your intention).

[MannyLNJ]

Well I'm using Excel 2010 actually.

[icestationzbra]

Well I'm using Excel 2010 actually.

well, it is very nice of you to fool us all by putting 2003 in your profile... i found it very funny, made my weekend.