In Google Sheet, we can use ROUND()
to round float to the nearest.
like
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 communityIn Google Sheet, we can use ROUND()
to round float to the nearest.
like
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?
Try ROUNDUP
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.