# ROUND Function - Round up to nearest whole number

Options
edited 12/09/19

Hello, I want to be able to round up a number to the nearest whole - for example 4.1 would round to 5, 4 would stay as 4

5.6 would round to 6.  any whole numbers would not round but stay the same.

• ✭✭✭
Options

I think that adding .49 (you may need to expand that however many decimals you might work with) to the number within the round formula will always round up.

I have heard of .5 but that would make an integer round up to the next one which won't do.

Round( x + .49)

So

4.5 rounds to 5

5 rounds to 5

5.01 rounds to 6

5.49 rounds to 6

Is that what you are looking for?

-Wilbs

• ✭✭✭✭✭✭
Options

Depending on the significant figures, 0.49 may not work (for example, 0.001 wil give incorrect answer)

This works for all significant digits.

=IF(Owner@row > INT(Owner@row), +1, 0) + INT(Owner@row)

If the numbers are negative and need to increase in magnitude (instead of rounding 'up'), that is a different problem, which I doubt applies here.

Craig

• Options