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?
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.