need help with an excel formula?

Question

ok here it is. im setting up a fantasy football spreadsheet.

i want to have a bunch of coloums on the top and the players on the left side going down.

10 yds rushing 10 yds receiving 20 yrds passing

vince young
marvin harrison

and so on with alot more ways to score and alot more players.

say 10 yds rushing is 2 points, 10 yds receiving is 3 points, and 20 yds passing are 5 points. m. harrison gets 80 rushing yds in the game, so i get 16 points. 80/10=8 8*2=16.

heres the question:
is there a way i can just enter 8 by marvin harrison under 10 yds rushing, and it will automatically times it by 2 and put 16 in that cell?
pretty much i want to give the different catagories a number value. all they way down for my 17 players.

if theres any people who know what im talking about and can help me, please do so. thanks

phil

Answer 1

What the first person recommended is pretty much correct, however I might do it a little differently since I'm guessing you want to print the results out and make it look all nice and neat.

I would have two different spreadsheets. One that you enter the data on. And another that displays the results. So say on Sheet1 you have a column for 10 yards rushing and a row for Marvin Harrison. Let's say the cell is C3 that you input the data in. On Sheet2 you make it look exactly the same except you add formulas into it. So cell C3 on Sheet2 would be:

=(Sheet1!C3/10)*2

or to simplify it:

=Sheet1!C3/5

Since this equation would equate to the same answer.

Those formula would take the 80 yards on Sheet1 divide it by 10 then multiply it by 2. Dividing something by 10 then multiplying it by 2 is the same as dividing by 5. That's why the second formula.

Sheet2 would be the sheet that you'd print out that has the points, while all of the data would be entered on Sheet1.

Answer 2

Not exactly possible to do as you ask in a normal excel spreadsheet, but...

You can enter the number (yards rushing for example) in one cell and in the CELL NEXT TO IT display the points you want automatically.

Enter your formula in the cell next to the cell where you type the information.