G
golfer18
fIGURE
AT BATS 135
hITS 75
BATTING AVERAGE ???
AT BATS 135
hITS 75
BATTING AVERAGE ???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Hi!
hits divided by at bats
A1 = 135
B1 = 75
=B1/A1
Format the cell as .000
Biff
hits divided by at bats
A1 = 135
B1 = 75
=B1/A1
Format the cell as .000
Biff
G
Gord Dibben
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
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
G
golfer18
THANKS BIFF...WORKED PERFECT
GOLFER 18
GOLFER 18
Biff said:Hi!
hits divided by at bats
A1 = 135
B1 = 75
=B1/A1
Format the cell as .000
Biff
B
Biff
You're welcome! Thanks for the feedback.
Biff
Biff
golfer18 said:THANKS BIFF...WORKED PERFECT
GOLFER 18