You need to describe your requirements a little better - are you trying
to calculate the total net score for the last three rounds, with the
net score for each round being calculated as the Gross score for that
round minus Adjusted Handicap, where Adjusted Handicap is 85% of actual
handicap for handicaps 0-10, 80% of actual for 11-20 and 75% of actual
for handicaps greater than 20?

Or are you trying to calculate new handicaps based on the last three
rounds, and, if so, could you explain your rules for calculating new
handicaps?

DOR


LOU wrote:
I am trying to write this in excel can someone help me with this. I have
tried the if and but no success.

The criteria are as follows.

Handicaps. 3 scores are used with the oldest score dropping
out when the new round is played. 90% of a gross handicap between 0 -
10 for the net; 85% of 11 - 20; 80% of 21 - 30 and lastly 75% of 31 -
40.