Excel question - Fantasy Baseball Cafe 2015 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Excel question

Moderator: Baseball Moderators

Excel question

Postby Broncmet724 » Mon Feb 12, 2007 1:36 pm

Doing some projections for my baseball stuff. Learned a lot about the forumlas on various websites. But, I couldn't find anything on rounding fractions up to the last three numerals. You know, 0.333 for example. Any help guys?

Thanks
Image
Broncmet724 Beginner
Major League Manager
Major League Manager

User avatar

Posts: 1754
Joined: 8 Apr 2003
Home Cafe: Baseball
Location: On the outside looking in

Postby knapplc » Mon Feb 12, 2007 1:41 pm

Right-click on any cell you want rounded, choose "Format Cells" from the menu, and click the "Numbers" tab (it should be the one on the far left). Select "Number" from the list on the left, and choose the number of decimal places you want the cell to show on the option area to the right.
Keep wreves in General Talk in 2011!
knapplc
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicGolden Eagle Eye
Posts: 7871
(Past Year: 1)
Joined: 27 Dec 2004
Home Cafe: Football
Location: It's "ell see." ELL SEE!!!

Postby roninmedia » Mon Feb 12, 2007 1:42 pm

Select and right-click the cell(s)

Format Cells

Under Number, choose number and set the # of decimal places
roninmedia
Major League Manager
Major League Manager

User avatar
CafeholicEagle Eye
Posts: 1647
Joined: 16 Jul 2003
Home Cafe: Baseball

Postby The Artful Dodger » Mon Feb 12, 2007 1:47 pm

knapplc wrote:Right-click on any cell you want rounded, choose "Format Cells" from the menu, and click the "Numbers" tab (it should be the one on the far left). Select "Number" from the list on the left, and choose the number of decimal places you want the cell to show on the option area to the right.


It's also easy if say, you wanted an entire row or column to round up to a desired number of decimals...you select the row or column (on the left hand side or on the top side, respectively) and do the same procedure. That way, you never have to keep formatting the cells individually. If you really want to be a smarty-pants, just use the keystroke Ctrl-1 (or Apple-1 in Mac) to Format Cells. ;-)
Image

It's kinda like the Old Cafe - http://fbc2.freeforums.net
The Artful Dodger
Chief Wikitect
Chief Wikitect

User avatar
CafeholicResponse TeamFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyePick 3 Weekly WinnerMatchup Meltdown SurvivorLucky Ladders Weekly Winner
Posts: 21947
(Past Year: 670)
Joined: 3 Feb 2006
Home Cafe: Baseball
Location: Downloading rice

Postby knapplc » Mon Feb 12, 2007 1:55 pm

The Artful Dodger wrote:
knapplc wrote:Right-click on any cell you want rounded, choose "Format Cells" from the menu, and click the "Numbers" tab (it should be the one on the far left). Select "Number" from the list on the left, and choose the number of decimal places you want the cell to show on the option area to the right.


It's also easy if say, you wanted an entire row or column to round up to a desired number of decimals...you select the row or column (on the left hand side or on the top side, respectively) and do the same procedure. That way, you never have to keep formatting the cells individually. If you really want to be a smarty-pants, just use the keystroke Ctrl-1 (or Apple-1 in Mac) to Format Cells. ;-)

I typically format one cell then use the Format Painter to copy that format to other cells. You can use the Format Painter on entire sections, too, which is nice if you want to create a section for each team in your league. You can copy/paste the headers, change the team name in each section, and copy the format of the stats you want from section to section.

Excel rocks. Plain and simple. ;-D
Keep wreves in General Talk in 2011!
knapplc
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicGolden Eagle Eye
Posts: 7871
(Past Year: 1)
Joined: 27 Dec 2004
Home Cafe: Football
Location: It's "ell see." ELL SEE!!!

Postby danleroi22 » Mon Feb 12, 2007 2:26 pm

Look for the little button with:

-an arrow... either right or left.
-zeroes... and decimal points.

Push the correct one until you reach the desired round.
Image
[b]Thanks Franchise for the sig!

The [url=http://www.fantasybaseballcafe.com/forums/viewtopic.php?p=2014799#2014799]CTU Agents[/url] of the Aces High Cafe Challenge League.[/b]
danleroi22 Beginner
Minor League Mentor
Minor League Mentor

User avatar
Eagle EyeWeb Supporter
Posts: 458
Joined: 14 Jun 2004
Home Cafe: Football
Location: A Marlins Fan... in Ray Country

Postby Broncmet724 » Mon Feb 12, 2007 5:10 pm

Thanks for the help guys
Image
Broncmet724 Beginner
Major League Manager
Major League Manager

User avatar

Posts: 1754
Joined: 8 Apr 2003
Home Cafe: Baseball
Location: On the outside looking in

Postby danleroi22 » Mon Feb 12, 2007 5:11 pm

Broncmet724 wrote:Thanks for the help guys


;-D
Image
[b]Thanks Franchise for the sig!

The [url=http://www.fantasybaseballcafe.com/forums/viewtopic.php?p=2014799#2014799]CTU Agents[/url] of the Aces High Cafe Challenge League.[/b]
danleroi22 Beginner
Minor League Mentor
Minor League Mentor

User avatar
Eagle EyeWeb Supporter
Posts: 458
Joined: 14 Jun 2004
Home Cafe: Football
Location: A Marlins Fan... in Ray Country

Postby Amazinz » Tue Feb 13, 2007 12:52 pm

Just wanted to point out that there are also functions: Round, RoundUp, RoundDown. In most cases I just use formatting like the guys above outlined but there is a difference since the formatted value has a different real value. If you do calculations that depend on the rounding you need to use the functions.
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters


Return to General Talk

Who is online

Users browsing this forum: No registered users and 4 guests

cron
Forums Articles & Tips Sleepers Rankings Leagues


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