Pos & Points Calculations

[Heatherlyn]

Hi, I need some help with developing a sheet that has the position a person finished with a point value added and a total points column:
Example

Driver: Finish Finish Total Points
DriverA 1 5

Points assigned would be 60, 56, 52, 50, 48, 46 etc per finish

[ELeGault]

Can you Mock up what you want to see in a file and post it. See the Yellow banner at the top of the page.

With that we can further assist.

If you have a pattern that is to be followed be sure to illustrate how it would look if the pattern was fulfilled so that we can understand the output even if the logic is not clearly stated.

Do your best and someone here will do theirs to assist!

Have a great day!