Greetings!
I have attached a spreadsheet in which I am trying to accomplish the following:
1) Calculate a bowling handicap which is based on 90% of 225, and rounded down to the nearest whole number. Thus the formula in C5 - =SUM(225-B5)*(0.9)
My problem is I can't figure out how to incorporate ROUNDDOWN with the formulaIn the example of an average of 204, the calculation is 18.9 but I need the cell to read 18.
2) After the values are entered for the bowling scores I want to identify the top two scores for each game, 1 through 3, of "scratch scores" Columns F-H, and "handicap scores" for games 1-3 in columns I-K. A bowler may choose to enter EITHER or BOTH Scratch Pot Entry (col D) Handicap Pot Entry (col E) as signified by an "x". Thus their scores will only be valid for the top two score prizes if they are entered. SO, if they happened to have the high score for any given game in the scratch scores for example, but did not pay to enter, they shouldn't be identified as a winner. IF/THEN statement here I suppose?
3) I was thinking of identifying the top two scores for each game by highlighting them in yellow. How would I write formula for this?
4) Ultimately, I'd also like a separate area that shows any given game scores in order high to low, with the bowlers name, average and handicap. So for example, an area that would include columns A - C, and the column F, in order of the highest to lowest scores. Then the same for column G, H and so on, so that when a bowler looks to see who won a certain game, they can more readily see who was closest if the scores are in order.
Thanks for any help!
John
Bookmarks