I looked at your post the last time (a couple of weeks ago, wasn't it?) but
your link had xml files. If you convert it to an xls file I'll have a look.

Biff

"kevhatch" wrote in message
...
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