Scoring function not quite right?

[Simon Lloyd]

I am trying to create a golf scoring system for ou
society............yes i know its boring!, i have most of the function
in place but when it calculates anything less than 18 it still gives
net deduction. I have attatched a zipped file, its not very large an
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
+-------------------------------------------------------------------

 

[Biff]

Hi!

Change the formula in Sheet1 E5 to:

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

Copy down

Biff

"Simon Lloyd" <Simon.Lloyd.27kfjm_1147220702.4852@excelforum-nospam.com>
wrote in message
news:Simon.Lloyd.27kfjm_1147220702.4852@excelforum-nospam.com...

 

[Simon Lloyd]

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

Thanks again,

Simon

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

"Simon Lloyd" <Simon.Lloyd.27ltjm_1147285503.0168@excelforum-nospam.com>
wrote in message
news:Simon.Lloyd.27ltjm_1147285503.0168@excelforum-nospam.com...