Scoring function not quite right?
 

I am trying to create a golf scoring system for our
society............yes i know its boring!, i have most of the functions
in place but when it calculates anything less than 18 it still gives a
net deduction. I have attatched a zipped file, its not very large and
there is a little explanation on the scorecard page.

Hope you can help,

Simon.


+-------------------------------------------------------------------+
|Filename: golf scorecard.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4740 |
+-------------------------------------------------------------------+

--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=540504

Scoring function not quite right?
 

Hi!

Change the formula in Sheet1 E5 to:

=IF(D5="",0,IF(C5D$1,D5,IF($C5<$D$1-18,D5-2,D5-1)))

Copy down

Biff

"Simon Lloyd"
wrote in message
...

I am trying to create a golf scoring system for our
society............yes i know its boring!, i have most of the functions
in place but when it calculates anything less than 18 it still gives a
net deduction. I have attatched a zipped file, its not very large and
there is a little explanation on the scorecard page.

Hope you can help,

Simon.


+-------------------------------------------------------------------+
|Filename: golf scorecard.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4740 |
+-------------------------------------------------------------------+

--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=540504

Scoring function not quite right?
 

Thanks Biff, worked a treat, it's been driving me mad because i didnt
know how to nest the if statement!

Thanks again,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=540504

Scoring function not quite right?
 

You're welcome. Thanks for the feedback!

Biff

"Simon Lloyd"
wrote in message
...

Thanks Biff, worked a treat, it's been driving me mad because i didnt
know how to nest the if statement!

Thanks again,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=540504