Sign in to join the conversation:
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.
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
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!
Hello, I am looking to project an automated graph that shows the past 6 months in a dashboard. I have a sheet that has a date column with information from the past two years. Also, three different descriptions "Expedited", "Redo", and "Expedited and Redo". I used this formula to get the date from the past 6 months as a…
I am a heavy Smartsheet user. On a normal day, I have over 50 browser tabs open, each with their own Smartsheet. I use Chrome and have them grouped in Chrome tab groups. I have been using Smartsheet like this for years. In the past couple of months, I have seen a major bug. The tabs will occasionally log out. This is…
This discussion was created from comments split from: Column keeps auto-hiding when I don't want it to.
