Hello everyone

I have a golf spreadsheet which at the end of each round calculates where
everyone is in relation to the twelve players.

I am ok with ranking the top set but am struggling with the bottom of the
table where joint positions exist.


The formula firstly checks to see if there are 12 players.

Then - if the cell is equal to top ($F$175) then the player has won and
loses two shots on the next round!
Then - if the cell is equal to second place ($F$175+1) then the player has
come second and loses one shot on the next round!
Then - if the cell is equal to bottom ($F$176) then the player has come last
and will be gifted two shots on the next round!
NOW THE COMPLICATED BIT!!
If the next back was ALWAYS 11th then that would be ok BUT if there is a
joint position then I am stumped for a calculation!

=IF($F$180=12,"",IF(F165=$F$175,"-2",IF(F165=$F$175+1,"-1",IF(F165=$F$176,"+
2",IF(AND(F165=$F$176-1,$F$177=1),"+1","")))))

I would be grateful for any help in working this out.


Thanks


John in North Yorkshire UK