ROUND Function - Round up to nearest whole number

LouSnz
LouSnz
edited 12/09/19 in Smartsheet Basics

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.

Comments

  • Wilbsguy
    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
    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

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