Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 05, 12:44 AM
golfer18
 
Posts: n/a
Default hOW TO USE EXCEL TO CALCULATE BASEBALL BATTING AVERAGE

fIGURE
AT BATS 135
hITS 75

BATTING AVERAGE ???

  #2   Report Post  
Old April 27th 05, 01:32 AM
Biff
 
Posts: n/a
Default

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   Report Post  
Old April 27th 05, 01:43 AM
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
Old April 27th 05, 01:51 AM
golfer18
 
Posts: n/a
Default

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   Report Post  
Old April 27th 05, 05:11 AM
Biff
 
Posts: n/a
Default

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
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
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Excel: Is there a way to calculate the date as week of month? debra adams Excel Discussion (Misc queries) 2 January 3rd 05 09:39 PM
Calculate date of birth in Excel jamaicansuga Excel Worksheet Functions 2 November 11th 04 03:34 PM
How to calculate the data in excel 2002 including only the last 9. TylerMaricich Excel Worksheet Functions 6 November 8th 04 07:27 AM


All times are GMT +1. The time now is 01:52 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017