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)
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,