desperate Excel help? - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

desperate Excel help?

Moderator: Baseball Moderators

desperate Excel help?

Postby reiser » Fri Mar 25, 2005 10:33 pm

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
Minor League Mentor

User avatar

Posts: 641
(Past Year: 1)
Joined: 17 Feb 2004
Home Cafe: Baseball

Postby SHOCKandAWE » Fri Mar 25, 2005 10:37 pm

=SUM(AtBATS/Hits)*0.1

i hope this helps!
Image
SHOCKandAWE
General Manager
General Manager

User avatar
CafeholicCafe RankerCafe MusketeerPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

Postby SHOCKandAWE » Fri Mar 25, 2005 10:38 pm

=SUM(A1/B1)*0.1

SUB IN A1 for ATBATS and B1 for HITS

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

User avatar
CafeholicCafe RankerCafe MusketeerPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

Postby reiser » Fri Mar 25, 2005 10:40 pm

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
Minor League Mentor

User avatar

Posts: 641
(Past Year: 1)
Joined: 17 Feb 2004
Home Cafe: Baseball

Postby Tavish » Fri Mar 25, 2005 10:41 pm

ummm BA is H/AB
Tavish
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11066
(Past Year: 70)
Joined: 3 May 2004
Home Cafe: Baseball

Postby SHOCKandAWE » Fri Mar 25, 2005 10:51 pm

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

User avatar
CafeholicCafe RankerCafe MusketeerPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

Postby Tavish » Fri Mar 25, 2005 10:55 pm

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
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11066
(Past Year: 70)
Joined: 3 May 2004
Home Cafe: Baseball

Postby SHOCKandAWE » Fri Mar 25, 2005 11:23 pm

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 ;-D
Image
SHOCKandAWE
General Manager
General Manager

User avatar
CafeholicCafe RankerCafe MusketeerPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

Postby Tavish » Fri Mar 25, 2005 11:29 pm

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 ;-D




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
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterWeb Supporter
Posts: 11066
(Past Year: 70)
Joined: 3 May 2004
Home Cafe: Baseball

Postby SHOCKandAWE » Fri Mar 25, 2005 11:31 pm

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!
Image
SHOCKandAWE
General Manager
General Manager

User avatar
CafeholicCafe RankerCafe MusketeerPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 3522
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

Next

Return to Baseball Leftovers

Who is online

Users browsing this forum: HotRephoantee, Izenhart, lesleyls16, margaritaht1, NikkiSixx and 12 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Friday, Apr. 18
(All times are EST, weather icons show forecast for game time)

Toronto at Cleveland
(2:20 pm)
LA Angels at Detroit
(7:05 pm)
Milwaukee at Pittsburgh
(7:05 pm)
St. Louis at Washington
(7:05 pm)
Miami at Miami
(7:08 pm)
indoors
NY Yankees at Tampa Bay
(7:10 pm)
indoors
Seattle at Seattle
(7:10 pm)
Atlanta at NY Mets
(7:10 pm)
Baltimore at Boston
(7:10 pm)
Chi White Sox at Texas
(8:05 pm)
Minnesota at Kansas City
(8:10 pm)
Philadelphia at Colorado
(8:40 pm)
Houston at Oakland
(10:05 pm)
Arizona at LA Dodgers
(10:10 pm)
San Francisco at San Diego
(10:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact