hOW TO USE EXCEL TO CALCULATE BASEBALL BATTING AVERAGE
 

fIGURE
AT BATS 135
hITS 75

BATTING AVERAGE ???

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 ???

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 ???

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 ???

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 ???