Forum Discussion
Help please. Formula for Children's Athletics 100m Handicap.
Hi Excel Community. I have been given the task of creating a spreadsheet to map the 100m handicaps for our local athletics club. I have attached a pdf copy of the formula and what I have done so fa...
Neilo420 I applied the change you indicated in the "same winner" calculation, and arrive to the desired handicap adjustment. Please see the attached file and the picture below.
By the way, the formulae in columns R, Y and AF now also include a test that sees to it that the handicap can not go below 0, as I believe that was also one of your requirements from reading your original formulae. I had already included a test to maximise the handicap to 30.
Riny_van_Eekelen - Thank you Sir!
Your adjustments have worked on my end too and all the calculations work.
You sir, are a scholar and a gentleman.
Many thanks once again for all of your help here.
Best regards,
Neil.
Your adjustments have worked on my end too and all the calculations work.
You sir, are a scholar and a gentleman.
Many thanks once again for all of your help here.
Best regards,
Neil.