desperate Excel help? - Fantasy Baseball Cafe 2014

## 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: 11070
(Past Year: 26)
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: 11070
(Past Year: 26)
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: 11070
(Past Year: 26)
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

### Who is online

Users browsing this forum: No registered users and 5 guests

Forums Articles & Tips Sleepers Rankings Leagues

Today's Games
Sunday, Sep. 21
(All times are EST, weather icons show forecast for game time)

 • Toronto at NY Yankees(1:05 pm)
 • Washington at Miami(1:10 pm)
 • NY Mets at Atlanta(1:35 pm)
 • Boston at Baltimore(1:35 pm)
 • Milwaukee at Pittsburgh(1:35 pm)
 • Chi White Sox at Tampa Bay(1:40 pm)
 • Cleveland at Minnesota(2:10 pm)
 • Detroit at Kansas City(2:10 pm)
 • Seattle at Houston(2:10 pm)
 • LA Dodgers at Chi Cubs(2:20 pm)
 • Texas at LA Angels(3:35 pm)