hOW TO USE EXCEL TO CALCULATE BASEBALL BATTING AVERAGE

  • Thread starter Thread starter Guest
  • Start date Start date
Hi!

hits divided by at bats

A1 = 135
B1 = 75

=B1/A1

Format the cell as .000

Biff
 
Same way you would do it with pencil and paper.

Hits divided by at bats.

=75/135 returns .555 (sign that batter immediately)

Or with 135 in A1 and 75 in B1

=B1/A1 returns .555


The / mark is the divide by sign in Excel.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages... 1
how do i creat batting averages 4
Average of Subtotals in Pivot Table 0
HowTo: Baseball Calculator? 1
What function would let me find Batting Averages? 2
Calculate running average but not count a zero. 3
can someone please tell me what i did wrong with this if statement? 2
How do I get my data back in excel after hiting F11 by mistake? 1

Back
Top