Combining Average and Rounding up to x.x
Options
Hi
I need some assistance on a formula that will take the average of multiple numeric columns and then round to the nearest 1.0 [first decimal]. For instance, 1,1,3 average up to 1.666667  I would rather just have this round up to 1.7.
Best Answer

=ROUND(AVG(Number1, Number2, etc), 1)
This should accomplish what you want. ROUNDUP is not the command you would want. You just want ROUND.
Answers

=ROUND(AVG(Number1, Number2, etc), 1)
This should accomplish what you want. ROUNDUP is not the command you would want. You just want ROUND.

Awesome! Thanks Mike!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!