Jul 12 2022 08:21 PM
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 keeps rounding up to 48. What am I doing?
Jul 12 2022 09:21 PM
SolutionThe 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)
Jul 13 2022 03:43 AM - edited Jul 13 2022 03:48 AM
When apply Average formula it gives results 37.7 or with XX.XX decimals and added with round down (example result 10), in that case, result will be 37.7 + 10 = 47.7 , to get round off figure
prefix with round formula
=round(AVERAGE (210-E2)*90%+ROUNDDOWN(F2,0),0)
Average formula have not rounded, that is why getting decimals
Second part of Rounddown formula only rounded figure,
Jul 13 2022 09:20 AM
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 |
Jul 18 2022 11:17 PM
Thanks for the help. It still rounds up if .06 or more and down if .05 or less. I added another column to the right of the calculation and stipulated no decimals and blacked out the other column.
Jul 12 2022 09:21 PM
SolutionThe 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)