Fantasy NASCAR team point tracker

[dwkmd]

New to Excel, need a way to track NASCAR fantasy team race results. Eight drivers remain the same all year and get a set amount of points for finishing first through 15th. Additional points are added for pole position and second. Need a way to have points add up dependent upon finishing position.

Thank you.

[dilipandey]

HI dwkmd,

welcome to the forum.
If you have sample data, upload that along with your expected results.. thanks.

Regards,
DILIPandey
<click on below * if this helps>

[dwkmd]

Here is an example. I am looking to automatically have the race result point total entered based on the inputing the finish position instead of having to manually enter the points.

[dilipandey]

Hi dwkmd,

Try using below formula:-

Please Login or Register  to view this content.

see attached:- Nascar.xls


Regards,
DILIPandey
<click on below * if this helps>