Notification

This article is about Looker Studio. For Looker documentation, visit https://cloud.google.com/looker/docs/intro.

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?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
7338425719934657138
true
Search Help Center
true
true
true
true
true
102097