Rounding up if over .5 and rounding down if .4

Kelly Yang

Hi,

How can I use a formula for rounding up if the number is .5 and higher and round down if the number is .4 and lower? 

For example:

2.3 = 2

2.6 = 3

 

Thanks,

Kelly

Jose da Silva

You can simply use the Decrease/Increase Decimal, on the top right of any spreadsheet.

J. Craig Williams

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

Kelly Yang

Thank you!