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
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
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: 11067
(Past Year: 26)
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: 11067
(Past Year: 26)
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: 11067
(Past Year: 26)
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: No registered users and 6 guests

Forums Articles & Tips Sleepers Rankings Leagues


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

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

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