CEIL Function (Gnumeric)
Round a number up to the nearest integer with Gnumeric CEIL. Includes numeric examples and how CEIL differs from CEILING.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
The CEIL function in Gnumeric is used for this task: Gnumeric documents CEIL as the smallest integer not less than the input. Do not confuse its one-argument form with CEILING and significance settings.
This guide explains how to read the formula, reproduce a concrete example, interpret its result and recognize common input mistakes.
Availability and version history
- Introduced: Documented by 1.12.62; original introduction not established.
- Availability: Supported in Gnumeric 1.12.62, based on the function-specific registration.
- Scope: Desktop; the fn-math function module must be included and enabled.
- Checked: October 14, 2026. Documentation/source check; no new native test in Gnumeric 1.12.62.
Syntax and arguments
CEIL(x)
Gnumeric formulas normally use commas (,) between arguments. These examples are written for Gnumeric rather than copied unchanged from LibreOffice Calc.
Worked example
=CEIL(2.2)
Expected result: 3.
Why it works: Finds the least integer greater than or equal to 2.2.
How to use it in your own spreadsheet
- Identify the cells or inputs that correspond to the sample values above.
- Enter the formula in an empty cell, changing the references or literal values to match your sheet.
- Compare the output with a manual check on a small known example.
- Extend the formula to a larger dataset only after you understand the result.
Common problems and practical checks
- Check the accepted numeric domain, units and array dimensions for the specific operation.
- If an error appears, check that the function arguments are of the expected type.
- A pasted formula may produce an error when it uses the other program’s argument separator or unsupported options.
Related functions
Documentation and verification
- Gnumeric official function reference
- Gnumeric function catalog
- Formula and intended behavior were checked against the Gnumeric official function reference; Gnumeric itself was not run in this environment.