Calculation help from average total

[Middlemix]

I have a golf handicap spreadsheet with our own system for changing player
handicap.

The score is input into a a field, the average of that score is then worked
out in the next cell (from 12 players)

What i need to do from there is alter the players handicap. If the players
score is below or above 2 shot on the average then the handicap will stay the
same(bufferzone)

For every 1 shot below or above that, the players handicap will alter -0.2
or +0.2

i.e player handicap is 10, he scores 21 , the average scores on the day are
29.58
The buffer is 2 so the average is now 27.58 minus the score gives 6.58 this
then multiplyed by 0.2 gives an increase of 1.316. his handicap is then
revised to 22.3

I know it sound difficult but I know you lot are clever

Thanks

 

[Bob Phillips]

How about

=player_score+((average_score-2)-player_score)*0.2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)