Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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",""))))) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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",""))))) . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Nested If Loop Limitation for Excel 2003 | Excel Discussion (Misc queries) | |||
Nested loop | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested Loop Link | Excel Worksheet Functions |