How to round float to bigger integer?

Question

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?

Answer 1

Try ROUNDUP

Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

Answer 2

=ROUNDUP(A2; 0)

=ARRAYFORMULA(IF(LEN(A1:A); ROUNDUP(A1:A; 0); ))