Google Sheets Function: CEILING

The CEILING function rounds up a number based on the chosen factor.

Usage:

=CEILING(number)

or

=CEILING(number, factor)

Example of use

To round up a number to 0 decimal places and get an integer, enter:

=CEILING(A2)

This formula is equivalent to:

=CEILING(A2,1)

To round up a number to 2 decimal places, enter 0.01 as the second argument:

=CEILING(A2,0.01)