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!
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…
This discussion was created from comments split from: Generate documents from row data.
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday
