Assign point values to ranks

[JustinN1]

I have 3 rankings. The scores are in cells E5 to E7. I need a point value of 0, 1 or 2 listed in F5 to F7. I need 0 scored for the lowest, 1 scored for the middle and 2 scored for the highest. The problem I have is with a tie. If there is a tie I need it divided by 3 because there are only a total of 3 available points to score.

Sorry if I didn't explain this clear enough. I appreciate the help
Thanks!

[shg]

In F5 and copy down,

=SUMPRODUCT((E5>$E$5:$E$7) + (E5=$E$5:$E$7)/2) - 0.5

[JustinN1]

Thank u so much. I need the cells in column F to say 0 if nothing is entered into column E. I thought I would use the IF function but I can't get it to work.

Thanks again!!

[shg]

=if(e5="", 0, sumproduct((e5>$e$5:$e$7) + (e5=$e$5:$e$7)/2) - 0.5)