batting averages

[Guest]

does any one know who to set up a spead sheat that will I can track my team batting averages and on base averages. the basic math in number of hit divide by number of at bats, but I cant find the formula. Thank you for any help

 

[Kevin Stecyk]

pokerhrd wrote...

does any one know who to set up a spead sheat that will I can track my

team batting averages and on base averages. the basic math in number of hit
divide by number of at bats, but I cant find the formula. Thank you for any
help

I thought this would be a commonly asked question with plenty of answers. I
was right on the first part.

You can go here and put "baseball" (w/o quotes) in to the search and see
prior queries: http://www.google.com/advanced_group_search?q=group:*excel

You might also want to consider purchasing a program for $30. It might meet
your needs better? One program is located here:
http://www.basetobase.on.ca/

Hope this helps get you started.

Best regards,
Kevin

 

[JE McGimpsey]

If AB are in column B and hits in column C then BA:

=ROUND(C2/B2,3)

 

[Dave Peterson]

And to make it look "nice", try a custom format of:

..000