In Google Sheet, we can use
ROUND() to round float to the nearest.
5.2 = 5 5.5 = 6.
What if I want it:
5.2 = 6 5.5 = 6.
If the number exceeds by a decimal, then rounded off to +1. Any idea?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.