Repost - rank in if loops!
 

Dear all

In my golf spreadsheet I have a test for the 12 players as follows

If you are first then you lose 2 shots
If you are second you lose 1 shot
If you are last you get 2 shots back
and
If you are second last you get one shot back (even if there are a slack
handfull of you!!)

My problem is not 1st 2nd or last but second last!!

How do I code the following to cope with joint 9th!!?

Cheers

John
North Yorkshire UK


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