Forum Discussion
Solved
Formulas
I am using the following formula to track sou singles bowling tournament. =AVERAGE (210-E2)*90%+ROUNDDOWN(F2,0) The average function when done is 47.7, which should be rounded down to 47. Excel ke...
The formula as you present it calculates an average and then adds the rounded(down) value of whatever is in F2. So, what's in F2?
Perhaps you want it this way:
=ROUNDDOWN(AVERAGE (210-E2)*90%,0)
The formula as you present it calculates an average and then adds the rounded(down) value of whatever is in F2. So, what's in F2?
Perhaps you want it this way:
=ROUNDDOWN(AVERAGE (210-E2)*90%,0)
It works for tne one cell. Copy/paste gives the same number for rest of column
| BOWLERS NAME | S | LANE | AVG | HDCP | GAME 1 | TOTAL 1 | HDCP | GAME 2 | TOTAL 2 | HDCP | GAME 3 | TOTAL 3 | SERIES | |
| 1 | YOLANDA SULLIVAN | S | 58 | 157 | 47.0 | |||||||||
| 2 | KEVIN RICKS | M | 57 | 188 | 47.0 | |||||||||
| 3 | DANNINE PRITCHARD | F | 60 | 158 | 47 | |||||||||
| 4 | MARTHA WILLIAMS | F | 57 | 148 | 47 |