Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 03-21-2005, 07:38 PM   #1
Baseband Member
 
Join Date: Feb 2005
Posts: 42
Default **Need help with this darn excel**

I'm in a fantasy baseball league and I want to see how many pts my team would end up with if they repeated last years numbers, also want to tweak some numbers to my projections and such, so I figured excel would be awesome instead of busting out the ol calculator.

I can't seem to figure out how to get a formula to make each category work tho! What I did was I listed all my players on the left side going down, and then listed the categories going across on top. I filled in the numbers for a couple players, and I tried to modify the categories as approriate. Example, a HR is worth a total of 5 pts, so I entered 5 under the category HR, clicked =, clicked the 5, then typed in how many homers my player hit in the approriate box. But when I go and drag the formula down, it changes and does not stay constant with the cell that the 5 is in, rather goes down to the next cell, and then the next, etc...

I want to make it so a whole column has a formula for it, like 5 * X number of HRs, then the next column have 3 * X number of triples my player has, so on and so forth.

Thanks for listening to what was probably a hella confusing post lol
__________________

2004 GT RagTop is offline   Reply With Quote
Old 03-21-2005, 08:13 PM   #2
Baseband Member
 
Join Date: Feb 2005
Posts: 42
Default Re: **Need help with this darn excel**



anyone??
__________________

2004 GT RagTop is offline   Reply With Quote
Old 03-21-2005, 08:24 PM   #3
Beta Member
 
Join Date: Mar 2005
Posts: 5
Default

post the excel file so we can see exactly what ur working with
Elusive Peanut is offline   Reply With Quote
Old 03-21-2005, 08:50 PM   #4
Baseband Member
 
Join Date: Feb 2005
Posts: 42
Default Re: **Need help with this darn excel**



Thats where i'm at, I want a formula for the whole column of runs, doubles, tripes, homers, etc... So that way when I plug in the next batters numbers, it automatically multiplies the numbers for me, thus making life easier for me lol
2004 GT RagTop is offline   Reply With Quote
Old 03-22-2005, 02:10 PM   #5
Baseband Member
 
Join Date: Feb 2005
Posts: 42
Default Re: **Need help with this darn excel**

....???
2004 GT RagTop is offline   Reply With Quote
Old 03-22-2005, 03:26 PM   #6
Daemon Poster
 
zero4zero's Avatar
 
Join Date: Jan 2005
Posts: 563
Default Re: **Need help with this darn excel**

You'll have to learn who excel macros' work and what are the functions. A "X" is actually a cell number in your case. It's like mathematics, once you've learned it, you can write any macros and know how to apply it in your spreadsheet. Read the help file a bit!
__________________

__________________
Asus P4P800 SE
Intel P4 3.2 Gig 1024 Meg PC3200 cas latency 2.5
RAID 0 2-36.7 Gig SATA WD 10,000 RPM
200 Gig WD ATI ALL-IN-WONDER 9600XT
6500 Kb bandwith Internet Connection
zero4zero is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 07:28 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0