Floor and Ceiling Functions

Floor and ceiling functions
Floor function
Ceiling function

In mathematics and computer science, the floor function is the function that takes as input a real number ${\displaystyle x}$ and gives as output the greatest integer less than or equal to ${\displaystyle x}$, denoted ${\displaystyle \operatorname {floor} (x)=\lfloor x\rfloor }$. Similarly, the ceiling function maps ${\displaystyle x}$ to the least integer greater than or equal to ${\displaystyle x}$, denoted ${\displaystyle \operatorname {ceil} (x)=\lceil x\rceil }$.[1]

For example, ${\displaystyle \operatorname {floor} (2.4)=\lfloor 2.4\rfloor =2}$ and ${\displaystyle \operatorname {ceil} (2.4)=\lceil 2.4\rceil =3}$ while ${\displaystyle \lfloor 2\rfloor =\lceil 2\rceil =2}$.

## Notation

The notion of integral part or integer part of x was first introduced by Adrien-Marie Legendre under the name entier (French for "integer") in 1798, when he needed the concept for his proof of the Legendre's formula.

Carl Friedrich Gauss introduced the square bracket notation ${\displaystyle [x]}$ in his third proof of quadratic reciprocity (1808).[2] This remained the standard[3] in mathematics until Kenneth E. Iverson introduced the names "floor" and "ceiling" and the corresponding notations ${\displaystyle \lfloor x\rfloor }$ and ${\displaystyle \lceil x\rceil }$ in his 1962 book A Programming Language.[4][5] Both notations are now used in mathematics;[6] this article follows Iverson.

In mathematics, the floor function can also be written with boldface or double brackets ${\displaystyle [\![x]\!]}$.[7] The ceiling function has another notation with reversed boldface or double brackets ${\displaystyle ]\!]x[\![}$ or just using normal reversed brackets ]x[.[8]

For negative values of x, the terms integral part or integer part of x are sometimes instead taken to be the value of the ceiling function, i.e., the value of x rounded to an integer towards 0. The language APL uses ?x; other computer languages commonly use notations like entier(x) (ALGOL), INT(x) (BASIC, MS Excel), or floor(x)(C, C++, R, and Python).[9]

The ceiling function is usually denoted by ceil(x) or less commonly ceiling(x) in non-APL computer languages that have a notation for this function. The J Programming Language, a follow on to APL that is designed to use standard keyboard symbols, uses >. for ceiling and <. for floor.[10]

The fractional part is the sawtooth function, denoted by ${\displaystyle \{x\}}$ for real x and defined by the formula[11]

${\displaystyle \{x\}=x-\lfloor x\rfloor .}$

For all x,

${\displaystyle 0\leq \{x\}<1.}$

### Examples

x Floor ${\displaystyle \lfloor x\rfloor }$ Ceiling ${\displaystyle \lceil x\rceil }$ Fractional part ${\displaystyle \{x\}}$
2 2 2 0
2.4 2 3 0.4
2.9 2 3 0.9
−2.7 −3 −2 0.3
−2 −2 −2 0

### Typesetting

The floor and ceiling functions are usually typeset with left and right square brackets where the upper (for floor function) or lower (for ceiling function) horizontal bars are missing, and, e.g., in the LaTeX typesetting system these symbols can be specified with the \lfloor, \rfloor, \lceil and \rceil commands in math mode. HTML 4.0 uses the same names: &lfloor;, &rfloor;, &lceil;, and &rceil;. Unicode contains codepoints for these symbols at U+2308-U+230B: ?x?, ?x?.

## Definition and properties

In the following formulas, x and y are real numbers, k, m, and n are integers, and ${\displaystyle \mathbb {Z} }$ is the set of integers (positive, negative, and zero).

Floor and ceiling may be defined by the set equations

${\displaystyle \lfloor x\rfloor =\max\{m\in \mathbb {Z} \mid m\leq x\},}$
${\displaystyle \lceil x\rceil =\min\{n\in \mathbb {Z} \mid n\geq x\}.}$

Since there is exactly one integer in a half-open interval of length one, for any real x there are unique integers m and n satisfying

${\displaystyle x-1

Then  ${\displaystyle \lfloor x\rfloor =m}$  and  ${\displaystyle \lceil x\rceil =n}$  may also be taken as the definition of floor and ceiling.

### Equivalences

These formulas can be used to simplify expressions involving floors and ceilings.[12]

{\displaystyle {\begin{aligned}\lfloor x\rfloor =m&\;\;{\mbox{ if and only if }}&m&\leq x

In the language of order theory, the floor function is a residuated mapping, that is, part of a Galois connection: it is the upper adjoint of the function that embeds the integers into the reals.

{\displaystyle {\begin{aligned}x

These formulas show how adding integers to the arguments affect the functions:

{\displaystyle {\begin{aligned}\lfloor x+n\rfloor &=\lfloor x\rfloor +n,\\\lceil x+n\rceil &=\lceil x\rceil +n,\\\{x+n\}&=\{x\}.\end{aligned}}}

The above are never true if n is not an integer; however, for every x, y the following inequalities hold:

{\displaystyle {\begin{aligned}\lfloor x\rfloor +\lfloor y\rfloor &\leq \lfloor x+y\rfloor \leq \lfloor x\rfloor +\lfloor y\rfloor +1,\\\lceil x\rceil +\lceil y\rceil -1&\leq \lceil x+y\rceil \leq \lceil x\rceil +\lceil y\rceil .\end{aligned}}}

### Relations among the functions

It is clear from the definitions that

${\displaystyle \lfloor x\rfloor \leq \lceil x\rceil ,}$   with equality if and only if x is an integer, i.e.
${\displaystyle \lceil x\rceil -\lfloor x\rfloor ={\begin{cases}0&{\mbox{ if }}x\in \mathbb {Z} \\1&{\mbox{ if }}x\not \in \mathbb {Z} \end{cases}}}$

In fact, for integers n:

${\displaystyle \lfloor n\rfloor =\lceil n\rceil =n.}$

Negating the argument switches floor and ceiling and changes the sign:

{\displaystyle {\begin{aligned}\lfloor x\rfloor +\lceil -x\rceil &=0\\-\lfloor x\rfloor &=\lceil -x\rceil \\-\lceil x\rceil &=\lfloor -x\rfloor \end{aligned}}}

and:

${\displaystyle \lfloor x\rfloor +\lfloor -x\rfloor ={\begin{cases}0&{\mbox{ if }}x\in \mathbb {Z} \\-1&{\mbox{ if }}x\not \in \mathbb {Z} ,\end{cases}}}$
${\displaystyle \lceil x\rceil +\lceil -x\rceil ={\begin{cases}0&{\mbox{ if }}x\in \mathbb {Z} \\1&{\mbox{ if }}x\not \in \mathbb {Z} .\end{cases}}}$

Negating the argument complements the fractional part:

${\displaystyle \{x\}+\{-x\}={\begin{cases}0&{\mbox{ if }}x\in \mathbb {Z} \\1&{\mbox{ if }}x\not \in \mathbb {Z} .\end{cases}}}$

The floor, ceiling, and fractional part functions are idempotent:

{\displaystyle {\begin{aligned}{\Big \lfloor }\lfloor x\rfloor {\Big \rfloor }&=\lfloor x\rfloor ,\\{\Big \lceil }\lceil x\rceil {\Big \rceil }&=\lceil x\rceil ,\\{\Big \{}\{x\}{\Big \}}&=\{x\}.\\\end{aligned}}}

The result of nested floor or ceiling functions is the innermost function:

{\displaystyle {\begin{aligned}{\Big \lfloor }\lceil x\rceil {\Big \rfloor }&=\lceil x\rceil ,\\{\Big \lceil }\lfloor x\rfloor {\Big \rceil }&=\lfloor x\rfloor .\\\end{aligned}}}

### Quotients

If m and n are integers and n ? 0,

${\displaystyle 0\leq \left\{{\frac {m}{n}}\right\}\leq 1-{\frac {1}{|n|}}.}$

If n is a positive integer[13]

${\displaystyle \left\lfloor {\frac {x+m}{n}}\right\rfloor =\left\lfloor {\frac {\lfloor x\rfloor +m}{n}}\right\rfloor ,}$
${\displaystyle \left\lceil {\frac {x+m}{n}}\right\rceil =\left\lceil {\frac {\lceil x\rceil +m}{n}}\right\rceil .}$

If m is positive[14]

${\displaystyle n=\left\lceil {\frac {n}{m}}\right\rceil +\left\lceil {\frac {n-1}{m}}\right\rceil +\dots +\left\lceil {\frac {n-m+1}{m}}\right\rceil ,}$
${\displaystyle n=\left\lfloor {\frac {n}{m}}\right\rfloor +\left\lfloor {\frac {n+1}{m}}\right\rfloor +\dots +\left\lfloor {\frac {n+m-1}{m}}\right\rfloor .}$

For m = 2 these imply

${\displaystyle n=\left\lfloor {\frac {n}{2}}\right\rfloor +\left\lceil {\frac {n}{2}}\right\rceil .}$

More generally,[15] for positive m (See Hermite's identity)

${\displaystyle \lceil mx\rceil =\left\lceil x\right\rceil +\left\lceil x-{\frac {1}{m}}\right\rceil +\dots +\left\lceil x-{\frac {m-1}{m}}\right\rceil ,}$
${\displaystyle \lfloor mx\rfloor =\left\lfloor x\right\rfloor +\left\lfloor x+{\frac {1}{m}}\right\rfloor +\dots +\left\lfloor x+{\frac {m-1}{m}}\right\rfloor .}$

The following can be used to convert floors to ceilings and vice versa (m positive)[16]

${\displaystyle \left\lceil {\frac {n}{m}}\right\rceil =\left\lfloor {\frac {n+m-1}{m}}\right\rfloor =\left\lfloor {\frac {n-1}{m}}\right\rfloor +1,}$
${\displaystyle \left\lfloor {\frac {n}{m}}\right\rfloor =\left\lceil {\frac {n-m+1}{m}}\right\rceil =\left\lceil {\frac {n+1}{m}}\right\rceil -1,}$

If m and n are positive and coprime, then

${\displaystyle \sum _{i=1}^{n-1}\left\lfloor {\frac {im}{n}}\right\rfloor ={\frac {1}{2}}(m-1)(n-1).}$

The above formule can be generalized for all m and n strictly positive integers:[17]

${\displaystyle \sum _{k=1}^{n-1}\left\lfloor {\frac {km}{n}}\right\rfloor ={\frac {(m-1)(n-1)+\gcd(m,n)-1}{2}}.}$

Since the right-hand side is symmetrical in m and n, this implies that

${\displaystyle \left\lfloor {\frac {m}{n}}\right\rfloor +\left\lfloor {\frac {2m}{n}}\right\rfloor +\dots +\left\lfloor {\frac {(n-1)m}{n}}\right\rfloor =\left\lfloor {\frac {n}{m}}\right\rfloor +\left\lfloor {\frac {2n}{m}}\right\rfloor +\dots +\left\lfloor {\frac {(m-1)n}{m}}\right\rfloor .}$

More generally, if m and n are positive,

{\displaystyle {\begin{aligned}&\left\lfloor {\frac {x}{n}}\right\rfloor +\left\lfloor {\frac {m+x}{n}}\right\rfloor +\left\lfloor {\frac {2m+x}{n}}\right\rfloor +\dots +\left\lfloor {\frac {(n-1)m+x}{n}}\right\rfloor \\=&\left\lfloor {\frac {x}{m}}\right\rfloor +\left\lfloor {\frac {n+x}{m}}\right\rfloor +\left\lfloor {\frac {2n+x}{m}}\right\rfloor +\dots +\left\lfloor {\frac {(m-1)n+x}{m}}\right\rfloor .\end{aligned}}}

This is sometimes called a reciprocity law.[18]

### Nested divisions

For positive integer n, and arbitrary real numbers m,x:[19]

${\displaystyle \left\lfloor {\frac {\lfloor x/m\rfloor }{n}}\right\rfloor =\left\lfloor {\frac {x}{mn}}\right\rfloor }$
${\displaystyle \left\lceil {\frac {\lceil x/m\rceil }{n}}\right\rceil =\left\lceil {\frac {x}{mn}}\right\rceil .}$

### Continuity and series expansions

None of the functions discussed in this article are continuous, but all are piecewise linear: the functions ${\displaystyle \lfloor x\rfloor }$, ${\displaystyle \lceil x\rceil }$, and ${\displaystyle \{x\}}$ have discontinuities at the integers.

${\displaystyle \lfloor x\rfloor }$  is upper semi-continuous and  ${\displaystyle \lceil x\rceil }$  and ${\displaystyle \{x\}}$  are lower semi-continuous.

Since none of the functions discussed in this article are continuous, none of them have a power series expansion. Since floor and ceiling are not periodic, they do not have uniformly convergent Fourier series expansions. The fractional part function has Fourier series expansion[20]

${\displaystyle \{x\}={\frac {1}{2}}-{\frac {1}{\pi }}\sum _{k=1}^{\infty }{\frac {\sin(2\pi kx)}{k}}}$

for x not an integer.

At points of discontinuity, a Fourier series converges to a value that is the average of its limits on the left and the right, unlike the floor, ceiling and fractional part functions: for y fixed and x a multiple of y the Fourier series given converges to y/2, rather than to x mod y = 0. At points of continuity the series converges to the true value.

Using the formula floor(x) = x − {x} gives

${\displaystyle \lfloor x\rfloor =x-{\frac {1}{2}}+{\frac {1}{\pi }}\sum _{k=1}^{\infty }{\frac {\sin(2\pi kx)}{k}}}$

for x not an integer.

## Applications

### Mod operator

For an integer x and a positive integer y, the modulo operation, denoted by x mod y, gives the value of the remainder when x is divided by y. This definition can be extended to real x and y, y ? 0, by the formula

${\displaystyle x{\bmod {y}}=x-y\left\lfloor {\frac {x}{y}}\right\rfloor .}$

Then it follows from the definition of floor function that this extended operation satisfies many natural properties. Notably, x mod y is always between 0 and y, i.e.,

if y is positive,

${\displaystyle 0\leq x{\bmod {y}}

and if y is negative,

${\displaystyle 0\geq x{\bmod {y}}>y.}$

Gauss's third proof of quadratic reciprocity, as modified by Eisenstein, has two basic steps.[21][22]

Let p and q be distinct positive odd prime numbers, and let

${\displaystyle m={\frac {p-1}{2}},}$ ${\displaystyle n={\frac {q-1}{2}}.}$

First, Gauss's lemma is used to show that the Legendre symbols are given by

${\displaystyle \left({\frac {q}{p}}\right)=(-1)^{\left\lfloor {\frac {q}{p}}\right\rfloor +\left\lfloor {\frac {2q}{p}}\right\rfloor +\dots +\left\lfloor {\frac {mq}{p}}\right\rfloor }}$

and

${\displaystyle \left({\frac {p}{q}}\right)=(-1)^{\left\lfloor {\frac {p}{q}}\right\rfloor +\left\lfloor {\frac {2p}{q}}\right\rfloor +\dots +\left\lfloor {\frac {np}{q}}\right\rfloor }.}$

The second step is to use a geometric argument to show that

${\displaystyle \left\lfloor {\frac {q}{p}}\right\rfloor +\left\lfloor {\frac {2q}{p}}\right\rfloor +\dots +\left\lfloor {\frac {mq}{p}}\right\rfloor +\left\lfloor {\frac {p}{q}}\right\rfloor +\left\lfloor {\frac {2p}{q}}\right\rfloor +\dots +\left\lfloor {\frac {np}{q}}\right\rfloor =mn.}$

Combining these formulas gives quadratic reciprocity in the form

${\displaystyle \left({\frac {p}{q}}\right)\left({\frac {q}{p}}\right)=(-1)^{mn}=(-1)^{{\frac {p-1}{2}}{\frac {q-1}{2}}}.}$

There are formulas that use floor to express the quadratic character of small numbers mod odd primes p:[23]

${\displaystyle \left({\frac {2}{p}}\right)=(-1)^{\left\lfloor {\frac {p+1}{4}}\right\rfloor },}$
${\displaystyle \left({\frac {3}{p}}\right)=(-1)^{\left\lfloor {\frac {p+1}{6}}\right\rfloor }.}$

### Rounding

For an arbitrary real number ${\displaystyle x}$, rounding ${\displaystyle x}$ to the nearest integer with tie breaking towards positive infinity is given by ${\displaystyle {\text{rpi}}(x)=\left\lfloor x+{\tfrac {1}{2}}\right\rfloor =\left\lceil {\tfrac {\lfloor 2x\rfloor }{2}}\right\rceil }$; rounding towards negative infinity is given as ${\displaystyle {\text{rni}}(x)=\left\lceil x-{\tfrac {1}{2}}\right\rceil =\left\lfloor {\tfrac {\lceil 2x\rceil }{2}}\right\rfloor }$.

If tie-breaking is away from 0, then the rounding function is ${\displaystyle {\text{ri}}(x)=\operatorname {sgn} (x)\left\lfloor |x|+{\tfrac {1}{2}}\right\rfloor }$, and rounding towards even, as is usual in the nearest integer function, can be expressed with the more cumbersome ${\displaystyle \lfloor x\rceil =\left\lfloor x+{\tfrac {1}{2}}\right\rfloor +\left\lceil {\tfrac {2x-1}{4}}\right\rceil -\left\lfloor {\tfrac {2x-1}{4}}\right\rfloor -1}$, which is the above expression for rounding towards positive infinity ${\displaystyle {\text{rpi}}(x)}$ minus an integrality indicator for ${\displaystyle {\tfrac {2x-1}{4}}}$.

### Truncation

The truncation of a nonnegative number is given by ${\displaystyle \lfloor x\rfloor .}$ The truncation of a nonpositive number is given by ${\displaystyle \lceil x\rceil }$.

The truncation of any real number can be given by: ${\displaystyle \operatorname {sgn} (x)\lfloor |x|\rfloor }$, where sgn(x) is the sign function.

### Number of digits

The number of digits in base b of a positive integer k is

${\displaystyle \lfloor \log _{b}{k}\rfloor +1=\lceil \log _{b}{(k+1)}\rceil .}$

### Factors of factorials

Let n be a positive integer and p a positive prime number. The exponent of the highest power of p that divides n! is given by the formula[24]

${\displaystyle \left\lfloor {\frac {n}{p}}\right\rfloor +\left\lfloor {\frac {n}{p^{2}}}\right\rfloor +\left\lfloor {\frac {n}{p^{3}}}\right\rfloor +\dots ={\frac {n-\sum _{k}a_{k}}{p-1}}}$

where ${\displaystyle n=\sum _{k}a_{k}p^{k}}$ is the way of writing n in base p. Note that this is a finite sum, since the floors are zero when pk > n.

### Beatty sequence

The Beatty sequence shows how every positive irrational number gives rise to a partition of the natural numbers into two sequences via the floor function.[25]

### Euler's constant (?)

There are formulas for Euler's constant ? = 0.57721 56649 ... that involve the floor and ceiling, e.g.[26]

${\displaystyle \gamma =\int _{1}^{\infty }\left({1 \over \lfloor x\rfloor }-{1 \over x}\right)\,dx,}$
${\displaystyle \gamma =\lim _{n\to \infty }{\frac {1}{n}}\sum _{k=1}^{n}\left(\left\lceil {\frac {n}{k}}\right\rceil -{\frac {n}{k}}\right),}$

and

${\displaystyle \gamma =\sum _{k=2}^{\infty }(-1)^{k}{\frac {\left\lfloor \log _{2}k\right\rfloor }{k}}={\tfrac {1}{2}}-{\tfrac {1}{3}}+2\left({\tfrac {1}{4}}-{\tfrac {1}{5}}+{\tfrac {1}{6}}-{\tfrac {1}{7}}\right)+3\left({\tfrac {1}{8}}-\dots -{\tfrac {1}{15}}\right)+\dots }$

### Riemann function (?)

The fractional part function also shows up in integral representations of the Riemann zeta function. It is straightforward to prove (using integration by parts)[27] that if ${\displaystyle \phi (x)}$ is any function with a continuous derivative in the closed interval [a, b],

${\displaystyle {\sum _{a

Letting ${\displaystyle \phi (n)={n}^{-s}}$ for real part of s greater than 1 and letting a and b be integers, and letting b approach infinity gives

${\displaystyle \zeta (s)=s\int _{1}^{\infty }{\frac {{\frac {1}{2}}-\{x\}}{x^{s+1}}}\,dx+{\frac {1}{s-1}}+{\frac {1}{2}}.}$

This formula is valid for all s with real part greater than −1, (except s = 1, where there is a pole) and combined with the Fourier expansion for {x} can be used to extend the zeta function to the entire complex plane and to prove its functional equation.[28]

For s = ? + i t in the critical strip (i.e. 0 < ? < 1),

${\displaystyle \zeta (s)=s\int _{-\infty }^{\infty }e^{-\sigma \omega }(\lfloor e^{\omega }\rfloor -e^{\omega })e^{-it\omega }\,d\omega .}$

In 1947 van der Pol used this representation to construct an analogue computer for finding roots of the zeta function.[29]

### Formulas for prime numbers

The floor function appears in several formulas characterizing prime numbers. One example is that a positive integer n is a prime if and only if[30]

${\displaystyle \sum _{m=1}^{\infty }\left(\left\lfloor {\frac {n}{m}}\right\rfloor -\left\lfloor {\frac {n-1}{m}}\right\rfloor \right)=2.}$

One may also give formulas for producing the prime numbers. For example, let pn be the nth prime, and for any integer r > 1, define the real number α by the sum

${\displaystyle \alpha =\sum _{m=1}^{\infty }p_{m}r^{-m^{2}}.}$

Then[31]

${\displaystyle p_{n}=\left\lfloor r^{n^{2}}\alpha \right\rfloor -r^{2n-1}\left\lfloor r^{(n-1)^{2}}\alpha \right\rfloor .}$

A similar result is that there is a number ? = 1.3064... (Mills' constant) with the property that

${\displaystyle \left\lfloor \theta ^{3}\right\rfloor ,\left\lfloor \theta ^{9}\right\rfloor ,\left\lfloor \theta ^{27}\right\rfloor ,\dots }$

are all prime.[32]

There is also a number ? = 1.9287800... with the property that

${\displaystyle \left\lfloor 2^{\omega }\right\rfloor ,\left\lfloor 2^{2^{\omega }}\right\rfloor ,\left\lfloor 2^{2^{2^{\omega }}}\right\rfloor ,\dots }$

are all prime.[32]

Let ?(x) be the number of primes less than or equal to x. It is a straightforward deduction from Wilson's theorem that[33]

${\displaystyle \pi (n)=\sum _{j=2}^{n}\left\lfloor {\frac {(j-1)!+1}{j}}-\left\lfloor {\frac {(j-1)!}{j}}\right\rfloor \right\rfloor .}$

Also, if n >= 2,[34]

${\displaystyle \pi (n)=\sum _{j=2}^{n}\left\lfloor {\frac {1}{\sum _{k=2}^{j}\left\lfloor \left\lfloor {\frac {j}{k}}\right\rfloor {\frac {k}{j}}\right\rfloor }}\right\rfloor .}$

None of the formulas in this section are of any practical use.[35][36]

### Solved problems

Ramanujan submitted these problems to the Journal of the Indian Mathematical Society.[37]

If n is a positive integer, prove that

(i)     ${\displaystyle \left\lfloor {\tfrac {n}{3}}\right\rfloor +\left\lfloor {\tfrac {n+2}{6}}\right\rfloor +\left\lfloor {\tfrac {n+4}{6}}\right\rfloor =\left\lfloor {\tfrac {n}{2}}\right\rfloor +\left\lfloor {\tfrac {n+3}{6}}\right\rfloor ,}$

(ii)     ${\displaystyle \left\lfloor {\tfrac {1}{2}}+{\sqrt {n+{\tfrac {1}{2}}}}\right\rfloor =\left\lfloor {\tfrac {1}{2}}+{\sqrt {n+{\tfrac {1}{4}}}}\right\rfloor ,}$

(iii)     ${\displaystyle \left\lfloor {\sqrt {n}}+{\sqrt {n+1}}\right\rfloor =\left\lfloor {\sqrt {4n+2}}\right\rfloor .}$

### Unsolved problem

The study of Waring's problem has led to an unsolved problem:

Are there any positive integers k >= 6 such that[38]

${\displaystyle 3^{k}-2^{k}\left\lfloor \left({\tfrac {3}{2}}\right)^{k}\right\rfloor >2^{k}-\left\lfloor \left({\tfrac {3}{2}}\right)^{k}\right\rfloor -2}$ ?

Mahler[39] has proved there can only be a finite number of such k; none are known.

## Computer implementations

Int function from floating-point conversion in C

Many programming languages (including C, C++,[40][41]PHP,[42][43]R,[44] and Python[45]) provide standard functions for floor and ceiling.

Most spreadsheet programs support some form of a ceiling function. Although the details differ between programs, most implementations support a second parameter--a multiple of which the given number is to be rounded to. For example, ceiling(2, 3) rounds 2 up to the nearest multiple of 3, giving 3. The definition of what "round up" means, however, differs from program to program.

Until Excel 2010, Microsoft Excel's ceiling function was incorrect for negative arguments; ceiling(-4.5) was -5. This has followed through to the Office Open XML file format. Excel 2010 now follows the standard definition.[46] Meanwhile, its roundup function continues to round away from zero.[47]

The OpenDocument file format, as used by OpenOffice.org, Libreoffice and others, follows the mathematical definition of ceiling for its ceiling function, with an optional parameter for Excel compatibility. For example, CEILING(-4.5) returns -4.

## Notes

1. ^ Graham, Knuth, & Patashnik, Ch. 3.1
2. ^ Lemmermeyer, pp. 10, 23.
3. ^ e.g. Cassels, Hardy & Wright, and Ribenboim use Gauss's notation, Graham, Knuth & Patashnik, and Crandall & Pomerance use Iverson's.
4. ^ Iverson, p. 12.
5. ^ Higham, p. 25.
6. ^ See the Wolfram MathWorld article.
7. ^
8. ^ Mathwords: Ceiling Function
9. ^ Sullivan, p. 86.
10. ^ "Vocabulary". J Language. Retrieved 2011.
11. ^ Graham, Knuth, & Patashnik, p. 70.
12. ^ Graham, Knuth, & Patashink, Ch. 3
13. ^ Graham, Knuth, & Patashnik, p. 73
14. ^ Graham, Knuth, & Patashnik, p. 85
15. ^ Graham, Knuth, & Patashnik, p. 85 and Ex. 3.15
16. ^ Graham, Knuth, & Patashnik, Ex. 3.12
17. ^ J.E.blazek, Combinatoire de N-modules de Catalan, Master's thesis, page 17.
18. ^ Graham, Knuth, & Patashnik, p. 94
19. ^ Graham, Knuth, & Patashnik, p. 71, apply theorem 3.10 with x/m as input and the division by n as function
20. ^ Titchmarsh, p. 15, Eq. 2.1.7
21. ^ Lemmermeyer, § 1.4, Ex. 1.32–1.33
22. ^ Hardy & Wright, §§ 6.11–6.13
23. ^ Lemmermeyer, p. 25
24. ^ Hardy & Wright, Th. 416
25. ^ Graham, Knuth, & Patashnik, pp. 77–78
26. ^ These formulas are from the defaultlogic.com resource article Euler's constant, which has many more.
27. ^ Titchmarsh, p. 13
28. ^ Titchmarsh, pp.14–15
29. ^ Crandall & Pomerance, p. 391
30. ^ Crandall & Pomerance, Ex. 1.3, p. 46. The infinite upper limit of the sum can be replaced with n. An equivalent condition is n > 1 is prime if and only if ${\displaystyle \sum _{m=1}^{\lfloor {\sqrt {n}}\rfloor }\left(\left\lfloor {\frac {n}{m}}\right\rfloor -\left\lfloor {\frac {n-1}{m}}\right\rfloor \right)=1}$ .
31. ^ Hardy & Wright, § 22.3
32. ^ a b Ribenboim, p. 186
33. ^ Ribenboim, p. 181
34. ^ Crandall & Pomerance, Ex. 1.4, p. 46
35. ^ Ribenboim, p.180 says that "Despite the nil practical value of the formulas ... [they] may have some relevance to logicians who wish to understand clearly how various parts of arithmetic may be deduced from different axiomatzations ... "
36. ^ Hardy & Wright, pp.344--345 "Any one of these formulas (or any similar one) would attain a different status if the exact value of the number ? ... could be expressed independently of the primes. There seems no likelihood of this, but it cannot be ruled out as entirely impossible."
37. ^ Ramanujan, Question 723, Papers p. 332
38. ^ Hardy & Wright, p. 337
39. ^ Mahler, K. On the fractional parts of the powers of a rational number II, 1957, Mathematika, 4, pages 122-124
40. ^ "C++ reference of floor function". Retrieved 2010.
41. ^ "C++ reference of ceil function". Retrieved 2010.
42. ^ "PHP manual for ceil function". Retrieved 2013.
43. ^ "PHP manual for floor function". Retrieved 2013.
44. ^ https://stat.ethz.ch/R-manual/R-devel/library/base/html/Round.html
45. ^ "Python manual for math module". Retrieved 2013.
46. ^ But the online help provided in 2010 does not reflect this behavior.
47. ^ Microsoft Office Support: ROUNDUP

## References

• J.W.S. Cassels (1957), An introduction to Diophantine approximation, Cambridge Tracts in Mathematics and Mathematical Physics, 45, Cambridge University Press
• Crandall, Richard; Pomerance, Carl (2001), Prime Numbers: A Computational Perspective, New York: Springer, ISBN 0-387-94777-9
• Graham, Ronald L.; Knuth, Donald E.; Patashnik, Oren (1994), Concrete Mathematics, Reading Ma.: Addison-Wesley, ISBN 0-201-55802-5
• Hardy, G. H.; Wright, E. M. (1980), An Introduction to the Theory of Numbers (Fifth edition), Oxford: Oxford University Press, ISBN 978-0-19-853171-5
• Nicholas J. Higham, Handbook of writing for the mathematical sciences, SIAM. ISBN 0-89871-420-6, p. 25
• ISO/IEC. ISO/IEC 9899::1999(E): Programming languages -- C (2nd ed), 1999; Section 6.3.1.4, p. 43.
• Iverson, Kenneth E. (1962), A Programming Language, Wiley
• Lemmermeyer, Franz (2000), Reciprocity Laws: from Euler to Eisenstein, Berlin: Springer, ISBN 3-540-66957-4
• Ramanujan, Srinivasa (2000), Collected Papers, Providence RI: AMS / Chelsea, ISBN 978-0-8218-2076-6
• Ribenboim, Paulo (1996), The New Book of Prime Number Records, New York: Springer, ISBN 0-387-94457-5
• Michael Sullivan. Precalculus, 8th edition, p. 86
• Titchmarsh, Edward Charles; Heath-Brown, David Rodney ("Roger") (1986), The Theory of the Riemann Zeta-function (2nd ed.), Oxford: Oxford U. P., ISBN 0-19-853369-1

Connect with defaultLogic
What We've Done
Led Digital Marketing Efforts of Top 500 e-Retailers.
Worked with Top Brands at Leading Agencies.
Successfully Managed Over \$50 million in Digital Ad Spend.
Developed Strategies and Processes that Enabled Brands to Grow During an Economic Downturn.