You need to provide the details on the entire point distribution. Also, how
should ties (if possible) be handled?

Typically, ties split the pool. For example...

1st place = 100 pts
2nd place = 75 pts

If there are 2 tied for 1st place they each recieve 100+75/2 = 87.5 pts


--
Biff
Microsoft Excel MVP


"Not too bright" <Not too wrote in message
...
I am trying to allocate points related to finishing position.
I have used "RANK" to determine finishing position.
Example:
IF D1=1 then D2=25
IF D1=2 then D2=20
IF D1=3 then D2=17
IF D1=4 then D2=15
etc. down to position 20 approx