Rounding up if over .5 and rounding down if .4
Options
Comments
-
You can simply use the Decrease/Increase Decimal, on the top right of any spreadsheet.
-
Does ROUND( cell-ref, 0) not work?
Craig
--update--
Increase/decrease does not change the value, only what is displayed.
The sum of 2.4 + 2.4 + 2.9 rounded is 8
The sum of ROUND(2.4.0) + ROUND(2.4.0) + ROUND(2.9.0) is 7
-
Thank you!