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!
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
