What function would let me find Batting Averages?
 

I want to find the career totals from a baseball simulation site. I copy the
stats it gives to excel, but instead of openning the calculater to figure out
the batting average of the players I want to make a function to do it. I
don't know which function to use though. I would also like to find the on
base percentage and slugging percenate through functions. So what I want to
do is have a 3 functions.
1. Divide C4 by D4
2. Divide C4 + L4 + Q4 by D4 + L4 + Q4
3. Divide C4 + H4 + I4 + I4 + J4 + J4 + J4 by D4

Thanks in advance for your help, Ted

I might be missing something but

1. =C4/D4
2. =(C4+L4+Q4)/(D4+L4+Q4)
3. =(C4+H4+I4+I4+J4+J4+J4)/D4

--

HTH

RP
(remove nothere from the email address if mailing direct)


"pertimesco" wrote in message
...
I want to find the career totals from a baseball simulation site. I copy
the
stats it gives to excel, but instead of openning the calculater to figure
out
the batting average of the players I want to make a function to do it. I
don't know which function to use though. I would also like to find the
on
base percentage and slugging percenate through functions. So what I want
to
do is have a 3 functions.
1. Divide C4 by D4
2. Divide C4 + L4 + Q4 by D4 + L4 + Q4
3. Divide C4 + H4 + I4 + I4 + J4 + J4 + J4 by D4

Thanks in advance for your help, Ted

Without knowing what's in each column...

Average:
=hits/AtBats
(at bats don't include walks/Hitbypitch/sacrifice flies/sac bunts/catcher's
interferance/obstruction)

Slugging pct:
=(singles+2*doubles+3*triples+4*HRs)/atbats

on Base pct:
=(hits+Walks+HitByPitch)/(atbats+walks/hitbypitch+sacrifice Flies)

http://mlb.mlb.com/NASApp/mlb/mlb/of..._scorer_10.jsp

Rule 10.22 (is where you'd want to start.)

pertimesco wrote:

I want to find the career totals from a baseball simulation site. I copy the
stats it gives to excel, but instead of openning the calculater to figure out
the batting average of the players I want to make a function to do it. I
don't know which function to use though. I would also like to find the on
base percentage and slugging percenate through functions. So what I want to
do is have a 3 functions.
1. Divide C4 by D4
2. Divide C4 + L4 + Q4 by D4 + L4 + Q4
3. Divide C4 + H4 + I4 + I4 + J4 + J4 + J4 by D4

Thanks in advance for your help, Ted

--

Dave Peterson