desperate Excel help? - Fantasy Baseball Cafe 2015

## desperate Excel help?

Moderator: Baseball Moderators

### desperate Excel help?

can anyone clue me in to how to properly display BA?
I have it setup as AB/H, but I can't figure out how to get it to display as .299 instead of 2.99. it's excel 2000 if that makes a difference.
thanks!
reiser
Minor League Mentor

Posts: 641
Joined: 17 Feb 2004
Home Cafe: Baseball

=SUM(AtBATS/Hits)*0.1

i hope this helps!
SHOCKandAWE
General Manager

Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

=SUM(A1/B1)*0.1

SUB IN A1 for ATBATS and B1 for HITS

The most mportant thing s to multiply by .1000
SHOCKandAWE
General Manager

Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

SHOCKandAWE wrote:=SUM(A1/B1)*0.1

SUB IN A1 for ATBATS and B1 for HITS

The most mportant thing s to multiply by .1000

gracias!
reiser
Minor League Mentor

Posts: 641
Joined: 17 Feb 2004
Home Cafe: Baseball

ummm BA is H/AB
Tavish
Mod in Retirement

Posts: 11071
(Past Year: 23)
Joined: 3 May 2004
Home Cafe: Baseball

yea but i thought maybe he already had it set up so I was just adding onto his formula. Yours is the easy way
SHOCKandAWE
General Manager

Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

SHOCKandAWE wrote:yea but i thought maybe he already had it set up so I was just adding onto his formula. Yours is the easy way

And the right way. With AB/H the worse the player is the better the ratio is.
Tavish
Mod in Retirement

Posts: 11071
(Past Year: 23)
Joined: 3 May 2004
Home Cafe: Baseball

Tavish wrote:
SHOCKandAWE wrote:yea but i thought maybe he already had it set up so I was just adding onto his formula. Yours is the easy way

And the right way. With AB/H the worse the player is the better the ratio is.

Now you have me confused
SHOCKandAWE
General Manager

Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

SHOCKandAWE wrote:
Tavish wrote:
SHOCKandAWE wrote:yea but i thought maybe he already had it set up so I was just adding onto his formula. Yours is the easy way

And the right way. With AB/H the worse the player is the better the ratio is.

Now you have me confused

Barry Bonds 135 H 373 AB
H/AB = 135/373 = .362
AB/H *.1 = 373/135 *.1 = .276

Michael Tucker 119 H 464 AB
H/AB = .256
AB/H * .1 = 464/119*.1 = .390
Tavish
Mod in Retirement

Posts: 11071
(Past Year: 23)
Joined: 3 May 2004
Home Cafe: Baseball

reiser wrote:
SHOCKandAWE wrote:=SUM(A1/B1)*0.1

SUB IN A1 for ATBATS and B1 for HITS

The most mportant thing s to multiply by .1000

gracias!

QUICK! STOP THE PRESSES! I AM A GOOFBALL!
SHOCKandAWE
General Manager

Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

Next