To use this function, choose Calc > Calculator.

Rounds a number up based on the number of decimal places you specify.

Tip

Use the Floor function to round down.

Syntax

CEIL(number,decimals)

For number, specify the number or column of numbers you want to round. For decimals, specify the number of places to round to.
  • If decimals = 0, the number is rounded to the nearest integer greater than or equal to the number.
  • If decimals > 0, the number is rounded up to the specified number of decimal places after the decimal point.
  • If decimals < 0, the number is rounded up to 1 minus the specified number of place values to the left of the decimal point.

Examples

Calculator expression Result
CEIL (2.136, 0) 3
CEIL (2.136, 1) 2.2
CEIL (2.136, 2) 2.14
CEIL (−2.136, 1) −2.1
CEIL (253.6, −1) 260
CEIL (253.6, −2) 300