CEILING function

 

The Klipfolio CEILING function rounds numbers up to the nearest multiple of significance. 

The syntax for the CEILING function is:

CEILING ( data , significance )

 

Parameters

data The value to round. number vector
significance The multiple to which you want to round. number scalar

CEILING example

Let's look at some CEILING function examples.

 

A

1 2.5
2 -2.5

The following examples are based on the above text from an Excel spreadsheet:

CEILING ( A1 , 1 )

-> ["3"]

CEILING ( A2 , -2 )

-> ["-4"]

In the first example, ["2.5"] is rounded up to ["3"].

In the second example, ["-2.5"] is rounded up to ["-4"].

Related links: