Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add "FIND LINKS" to EXCEL Audit function | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
ISNULL function - can't find it | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Find function | Excel Worksheet Functions |