Calculating Fantasy Football scores

  • Thread starter Thread starter Kai Gray
  • Start date Start date
K

Kai Gray

Sorry for the strange request but here goes...

I am in a league that scores fantasy football points in a bizarre way.
For example, if a QB gets 1 TD he gets 10 points, 2=20, 3=30 and so
on. Is there a simple way to write that so I can just enter the total
# of TDs? So if a QB threw 5 TD's the result should be 150.

Thanks,
Kai
 
Set-up a vlookup table, say in D1:F10

In D1:D10 would be 1, 2, 3, ... 10

In E1:E10 would be 10, 20, 30, ... 100

In F1: =E1

In F2: =E2+F1
copy F2 down F2:F10
(col F gives the cumulative scores)

Name the range D1:F10 as say: Table

Assuming the total # of TDs is entered in col A,

put in B1: =VLOOKUP(A1,Table,3,FALSE)
copy down col B
 
doh! scratch this post..

Go with Daniel M's much simpler and more pointed solution
(heck, why didn't I think of that <g>)
 
Back
Top