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)
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.
LEEWOOL Not sure I follow. Is the problem solved?
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
