Data Studio is now Looker Studio. Looker Studio is still free, with the same features you already know. Looker Studio Pro offers improved asset management for enterprises, new team collaboration capabilities, and access to technical support. Learn more.

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

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

Related resources

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
102097
false
false