Repost - rank in if loops!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested loop with ranking 2
If then help required for joint places in a rank 1
ranking the bottom of the table 5
Lookup formula for purchased items with same invoice number 5
Weighted ranking of a series 3
Getting the Weekly Daily Average 2
help formula (ranking) 1
Pulling a currency variable through my arrays drops 3rd decimal? 3

Top