Fantasy Football Spreadsheet

[cmcasper]

This is probably simple for some of you, but I can't seem to figure it out. When using Excel to total team fantasy points, I need the total column to reflect 1 point for every FULL 10 yards rushing and receiving and 1 point for every FULL 25 yards passing. Meaning If a QB throws for 24 yards, that team would get 0 points, and if the QB throws for 49 points, that team would get 1 point. No decimal places or rounding up. Also, rushing/receiving yards don't get totaled, each is a separate entity, meaning 45 rushing yards and 59 receiving yards for the same player would not equal 104 rushing/receiving yards for a total of 10 points. It would be 9 points (4 for rushing and 5 for receiving). Thanks in advance for help!

 

[T. Valko]

This is probably simple for some of you, but I can't seem to figure it out. When using Excel to total team fantasy points, I need the total column to reflect 1 point for every FULL 10 yards rushing and receiving and 1 point for every FULL 25 yards passing. Meaning If a QB throws for 24 yards, that team would get 0 points, and if the QB throws for 49 points, that team would get 1 point. No decimal places or rounding up. Also, rushing/receiving yards don't get totaled, each is a separate entity, meaning 45 rushing yards and 59 receiving yards for the same player would not equal 104 rushing/receiving yards for a total of 10 points. It would be 9 points (4 for rushing and 5 for receiving). Thanks in advance for help!

For the rushing points:

A1 = rushing yards

=INT(A1/10)

For the passing points:

B1 = passing yards

=INT(B1/25)

 

[cmcasper]

Wow, so simple! Thanks for the quick response!

 

[T. Valko]

Wow, so simple! Thanks for the quick response!

You're welcome. Thanks for the feedback!