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
2007-09-09
18:11:31
·
2 answers
·
asked by
philatron
2
in
Software