Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Everyone
For all you golfers out there.....I am trying to create a spreadsheet and need some help converting a score into stableford points. My Handicap is 8 so i get a shot on the 8 hardest holes Hole 1 = Par 5 and is the 8th Hardest hole If i score 3 on hole 1 - 1 shot = 2 therfore = 5 Points If i score 4 on hole 1 - 1 shot = 3 therfore = 4 Points If i score 5 on hole 1 - 1 shot = 4 therfore = 3 Points If i score 6 on hole 1 - 1 shot = 5 therfore = 2 Points If i score 7 on hole 1 - 1 shot = 6 therfore = 1 Points If i score 8+ on hole 1 - 1 shot = 7+ therfore = 0 Points I Hope this makes sense, you probably need to be a golfer to understand or maybe not? Any help will be great |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
golf handicap 4 of last 5 scores | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
Football Scores | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Golf Handicap Using Last 5 Scores | Excel Worksheet Functions |