Nested loop with ranking

  • Thread starter Thread starter jp
  • Start date Start date
J

jp

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","")))))
 
Could it be because of your typo?
=...IF(F156=$F$175+1,"-1",...

Try removing +1 after $F$175

Isbjornen
 
Isbjornen

No, the +1 is to take the 2nd place which works fine.

I am looking for a piece of logic that will cater for second to last place
which could be 11th or any other joint number like joint 10th would be
second last possibly!!

Thanks for looking.


Cheers


John
 
Back
Top