Nested loop with ranking
 

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","")))))

Nested loop with ranking
 

Could it be because of your typo?
=...IF(F156=$F$175+1,"-1",...

Try removing +1 after $F$175

Isbjornen




-----Original Message-----
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","")))))


.

Nested loop with ranking
 

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