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.