Re: Handicap calculator Excel question


Frank Ketchum wrote:
"Larry Bud" <larrybud2002@xxxxxxxxx> wrote in message
news:1147195575.192243.84510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

INT(0.96*AVERAGE(SMALL(a1:a20,{1,2,3,4,5,6,7,8,9,10}))*10)/10

Your last 20 differentials are assumed to be in A1 to A20.

This takes the smallest 10 and averages them (truncated to the tenth,
that why I'm multiplying by 10 and taking the integer), then it takes
96%, and divides it by 10.


So, just to be clear, you do this (multiply then divide by 10) so that
excel does not round to the nearest tenth, but rather drops the digits after
the 1/10 th position, correct? If so I think I have to change my excel
*** because I am letting it round it off.

Correct, digits after the 10th are dropped according to the USGA
formula.

.

Loading