Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, Sorry for posting this twice but I got no replies from the first post.
I have a workbook for working out Net scores and Stableford points based on players handicap, par of the hole and stroke index of the hole (link below) I have had a lot of help from you guys with this(thanks) and would like to call on you once more! Hopefully it's just a formula tweak! The problem I am having is that when my Gross score for a hole returns a zero or minus Net score it won't show the points correctly i.e. 1 over par= 1point par=3 1 under par=2 2 under par=3 3 under par=4 4+under par=5 Hole 17 on the 19/04/2006 highlights the problem (I didn't get a hole in one :-(, just hit the wrong key when I entered the score, but I can dream!! Entering the correct score"2" has the same effect) Hope it makes sense to someone. http://www.flypicture.com?display=updone&id=rtD2lKXd Thx in advance Kev |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
golf handicap 4 of last 5 scores | Excel Discussion (Misc queries) | |||
conditional Formatting golf scores | Excel Discussion (Misc queries) | |||
sorting golf scores | Excel Discussion (Misc queries) | |||
excel for tracking golf scores or handicap | Excel Discussion (Misc queries) | |||
Golf Handicap Using Last 5 Scores | Excel Worksheet Functions |