Looker Studio is now called Data Studio. Learn more about this change.

CEIL

Returns the nearest integer, greater than or equal to the specified value.

Sample usage

CEIL(Height)

Syntax

CEIL( X )

Parameters

  • X - a field or expression containing at least one field.

Note

  • CEIL( X ) is always greater than or equal to X.

Examples

Example formula Input Output
CEIL(Height) 20.34 21
CEIL(Height) -40.3 -40
CEIL(Height) 50 50

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026年08月26日 UTC.