Bowling Secretary Spreadsheet

[rlabonte68]

I am trying to create a spreadsheet that will calculate averages and handicap. Bowl 3 games per week with an average each week, so an average after 3 games, 6 games and so forth. Handicap is calculated as such, 90% of 190. You subtract their average from 190 then times .9. I also need the handicap result to round down if decimal is .5 or lower and round up if over .5.

 

[rlabonte68]

I just realized that if the average is 185.2 or 185.8 it has to show 185. It cannot change until it goes to 186. Is that something you can do?

 

[Fluff]

So it must always round down, is that correct?

 

[rlabonte68]

yes that would be correct, i believe the handicap is the same

 

[Fluff]

In that case you can use

=ROUNDDOWN(AVERAGE(B2:D25),0)

and

=ROUNDDOWN((190-G2)*0.9,0)

 

[rlabonte68]

That's perfect, thanks again for the help!!!! Greatly Appreciated!!

 

[Fluff]

You're welcome.

 

[rlabonte68]

I found one more thing if you don't mind. the handicap can never go below 0. So any average above 190 has to be 0.

 

[Fluff]

Ok, try

=MAX(ROUNDDOWN((190-G2)*0.9,0),0)

 

[rlabonte68]

Thanks again, your awesome!!

 

[Fluff]

My pleasure.