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?
0
1
Try ROUNDUP
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
1
=ROUNDUP(A2; 0)=ARRAYFORMULA(IF(LEN(A1:A); ROUNDUP(A1:A; 0); ))
