I have a formula that basically awards 10 points to the person finishing 1st, 9 points 2nd and so on down to 10th.
=IF(Unofficial!G4=1,10,(IF(Unofficial!G4=2,9,(IF(Unofficial!G4=3,8,(IF(Unofficial!G4=4,7,(IF(Unofficial!G4=5,6,(IF(Unofficial!G4=6,5,(IF(Unofficial!G4=7,4,(IF(Unofficial!G4=8,3,(IF(Unofficial!G4=9,2,(IF(Unofficial!G4=10,1,)))))))))))))))))))
This works but I'm wondering if I can achieve the same result with a shorter more concise formula.
Any help much obliged, even if its only to say "stick with what you've got".
Bookmarks