Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
pertimesco
 
Posts: n/a
Default 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
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add "FIND LINKS" to EXCEL Audit function Ridgerunner_2 Excel Worksheet Functions 3 February 22nd 05 01:19 AM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 05:58 PM
ISNULL function - can't find it KitKat Excel Worksheet Functions 6 December 3rd 04 05:55 AM
Find a Function to use accross different worksheets R. Hale Excel Worksheet Functions 3 November 25th 04 08:07 AM
Find function Jahunga Excel Worksheet Functions 2 November 22nd 04 04:38 PM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"