| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
hOW TO USE EXCEL TO CALCULATE BASEBALL BATTING AVERAGE
fIGURE
AT BATS 135 hITS 75 BATTING AVERAGE ??? |
|
#2
|
|||
|
|||
|
Hi!
hits divided by at bats A1 = 135 B1 = 75 =B1/A1 Format the cell as .000 Biff "golfer18" wrote in message ... fIGURE AT BATS 135 hITS 75 BATTING AVERAGE ??? |
|
#3
|
|||
|
|||
|
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 On Tue, 26 Apr 2005 16:44:03 -0700, "golfer18" wrote: fIGURE AT BATS 135 hITS 75 BATTING AVERAGE ??? |
|
#4
|
|||
|
|||
|
THANKS BIFF...WORKED PERFECT
GOLFER 18 "Biff" wrote: Hi! hits divided by at bats A1 = 135 B1 = 75 =B1/A1 Format the cell as .000 Biff "golfer18" wrote in message ... fIGURE AT BATS 135 hITS 75 BATTING AVERAGE ??? |
|
#5
|
|||
|
|||
|
You're welcome! Thanks for the feedback.
Biff "golfer18" wrote in message ... THANKS BIFF...WORKED PERFECT GOLFER 18 "Biff" wrote: Hi! hits divided by at bats A1 = 135 B1 = 75 =B1/A1 Format the cell as .000 Biff "golfer18" wrote in message ... fIGURE AT BATS 135 hITS 75 BATTING AVERAGE ??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
| Calculate date of birth in Excel | Excel Worksheet Functions | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Linear Mode
