ROUND Function - Round up to nearest whole number

LouSnz

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.

Wilbsguy

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

 

J. Craig Williams

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

LouSnz

excellent thanks so much for your reply, this is great!