# 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 x, and gives as output the greatest integer less than or equal to x, denoted floor(x) or x. Similarly, the ceiling function maps x to the least integer greater than or equal to x, denoted ceil(x) or x.[1]

For example, ⌊2.4⌋ = 2, ⌊−2.4⌋ = −3, ⌈2.4⌉ = 3, and ⌈−2.4⌉ = −2.

The integral part or integer part of x, often denoted [x] is usually defined as the x if x is nonnegative, and x otherwise. For example, [2.4] = 2 and [−2.4] = −2. The operation of truncation generalizes this to a specified number of digits: truncation to zero significant digits is the same as the integer part.

Some authors define the integer part as the floor regardless of the sign of x, using a variety of notations for this.[2]

For n an integer, n⌋ = ⌈n⌉ = [n] = n.

## Notation

The integral part or integer part of a number (partie entière in the original) was first defined in 1798 by Adrien-Marie Legendre in 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).[3] This remained the standard[4] in mathematics until Kenneth E. Iverson introduced, in his 1962 book A Programming Language, the names "floor" and "ceiling" and the corresponding notations ${\displaystyle \lfloor x\rfloor }$ and ${\displaystyle \lceil x\rceil }$.[5][6] Both notations are now used in mathematics,[7] although Iverson's notation will be followed in this article.

In some sources, boldface or double brackets ${\displaystyle [\![x]\!]}$ are used for floor, and reversed brackets ${\displaystyle ]\!]x[\![}$ or ]x[ for ceiling.[8][9] Sometimes ${\displaystyle [x]}$ is taken to mean the round-toward-zero function.[citation needed]

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

${\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 (${\displaystyle \lfloor \,\rfloor }$ for floor and ${\displaystyle \lceil \,\rceil }$ for ceiling). These characters are provided in Unicode:

• U+2308 LEFT CEILING (HTML &#8968; · &lceil;, &LeftCeiling;)
• U+2309 RIGHT CEILING (HTML &#8969; · &rceil;, &RightCeiling;)
• U+230A LEFT FLOOR (HTML &#8970; · &LeftFloor;, &lfloor;)
• U+230B RIGHT FLOOR (HTML &#8971; · &rfloor;, &RightFloor;)

In the LaTeX typesetting system, these symbols can be specified with the \lfloor, \rfloor, \lceil and \rceil commands in math mode, and extended in size using \left\lfloor, \right\rfloor, \left\lceil and \right\rceil as needed.

## Definition and properties

Given real numbers x and y, integers k, m, n and the set of integers ${\displaystyle \mathbb {Z} }$, floor and ceiling may be defined by the 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 number x, there are unique integers m and n satisfying the equation

${\displaystyle x-1

where ${\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.[11]

{\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 affects 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 and 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, both floor and ceiling functions are the identity:

${\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&{\text{if }}x\in \mathbb {Z} \\-1&{\text{if }}x\not \in \mathbb {Z} ,\end{cases}}}$
${\displaystyle \lceil x\rceil +\lceil -x\rceil ={\begin{cases}0&{\text{if }}x\in \mathbb {Z} \\1&{\text{if }}x\not \in \mathbb {Z} .\end{cases}}}$

Negating the argument complements the fractional part:

${\displaystyle \{x\}+\{-x\}={\begin{cases}0&{\text{if }}x\in \mathbb {Z} \\1&{\text{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}}}

due to the identity property for integers.

### 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[12]

${\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[13]

${\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,[14] 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)[15]

${\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,}$

For all m and n strictly positive integers:[16][better source needed]

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

which, for positive and coprime m and n, reduces to

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

Since the right-hand side of the general case 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 +\cdots +\left\lfloor {\frac {(m-1)n+x}{m}}\right\rfloor .\end{aligned}}}

This is sometimes called a reciprocity law.[17]

### Nested divisions

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

${\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[19]

${\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.[20][21]

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:[22]

${\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 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}}}$.

### 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 a version of Legendre's formula[23]

${\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 ${\textstyle n=\sum _{k}a_{k}p^{k}}$ is the way of writing n in base p. 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.[24]

### Euler's constant (γ)

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

${\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}}-\cdots -{\tfrac {1}{15}}\right)+\cdots }$

### Riemann zeta 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)[26] 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.[27]

For s = σ + it in the critical strip 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.[28]

### Formulas for prime numbers

The floor function appears in several formulas characterizing prime numbers. For example, since ${\displaystyle \left\lfloor {\frac {n}{m}}\right\rfloor -\left\lfloor {\frac {n-1}{m}}\right\rfloor }$ is equal to 1 if m divides n, and to 0 otherwise, it follows that a positive integer n is a prime if and only if[29]

${\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 n-th 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[30]

${\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.[31]

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.[31]

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

${\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,[33]

${\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.[34][35]

### Solved problems

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

If n is a positive integer, prove that

1. ${\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 ,}$
2. ${\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 ,}$
3. ${\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[37]

${\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[38] 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

In most programming languages, the simplest method to convert a floating point number to an integer does not do floor or ceiling, but truncation. The reason for this is historical, as the first machines used ones' complement and truncation was simpler to implement (floor is simpler in two's complement). FORTRAN was defined to require this behavior and thus almost all processors implement conversion this way. Some consider this to be an unfortunate historical design decision that has led to bugs handling negative offsets and graphics on the negative side of the origin.[citation needed]

A bit-wise right-shift of a signed integer ${\displaystyle x}$ by ${\displaystyle n}$ is the same as ${\displaystyle \left\lfloor {\frac {x}{2^{n}}}\right\rfloor }$. Division by a power of 2 is often written as a right-shift, not for optimization as might be assumed, but because the floor of negative results is required. Assuming such shifts are "premature optimization" and replacing them with division can break software.[citation needed]

Many programming languages (including C, C++,[39][40] C#,[41][42] Java,[43][44] PHP,[45][46] R,[47] and Python[48]) provide standard functions for floor and ceiling, usually called floor and ceil, or less commonly ceiling.[49] The language APL uses ⌊x for floor. The J Programming Language, a follow-on to APL that is designed to use standard keyboard symbols, uses <. for floor and >. for ceiling.[50] ALGOL usesentier for floor.

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.

Microsoft Excel used almost exactly the opposite of standard notation, with INT for floor, and FLOOR meaning round-toward-zero, and CEILING meaning round-away-from-zero.[51] This has followed through to the Office Open XML file format. Excel 2010 now follows the standard definition.[52]

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. ^ 1) Luke Heaton, A Brief History of Mathematical Thought, 2015, ISBN 1472117158 (n.p.)
2) Albert A. Blank et al., Calculus: Differential Calculus, 1968, p. 259
3) John W. Warris, Horst Stocker, Handbook of mathematics and computational science, 1998, ISBN 0387947469, p. 151
3. ^ Lemmermeyer, pp. 10, 23.
4. ^ e.g. Cassels, Hardy & Wright, and Ribenboim use Gauss's notation, Graham, Knuth & Patashnik, and Crandall & Pomerance use Iverson's.
5. ^ Iverson, p. 12.
6. ^ Higham, p. 25.
7. ^ See the Wolfram MathWorld article.
8. ^
9. ^ Mathwords: Ceiling Function
10. ^ Graham, Knuth, & Patashnik, p. 70.
11. ^ Graham, Knuth, & Patashink, Ch. 3
12. ^ Graham, Knuth, & Patashnik, p. 73
13. ^ Graham, Knuth, & Patashnik, p. 85
14. ^ Graham, Knuth, & Patashnik, p. 85 and Ex. 3.15
15. ^ Graham, Knuth, & Patashnik, Ex. 3.12
16. ^ J.E.blazek, Combinatoire de N-modules de Catalan, Master's thesis, page 17.
17. ^ Graham, Knuth, & Patashnik, p. 94
18. ^ Graham, Knuth, & Patashnik, p. 71, apply theorem 3.10 with x/m as input and the division by n as function
19. ^ Titchmarsh, p. 15, Eq. 2.1.7
20. ^ Lemmermeyer, § 1.4, Ex. 1.32–1.33
21. ^ Hardy & Wright, §§ 6.11–6.13
22. ^ Lemmermeyer, p. 25
23. ^ Hardy & Wright, Th. 416
24. ^ Graham, Knuth, & Patashnik, pp. 77–78
25. ^ These formulas are from the Wikipedia article Euler's constant, which has many more.
26. ^ Titchmarsh, p. 13
27. ^ Titchmarsh, pp.14–15
28. ^ Crandall & Pomerance, p. 391
29. ^ 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}$ .
30. ^ Hardy & Wright, § 22.3
31. ^ a b Ribenboim, p. 186
32. ^ Ribenboim, p. 181
33. ^ Crandall & Pomerance, Ex. 1.4, p. 46
34. ^ 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 ... "
35. ^ 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."
36. ^ Ramanujan, Question 723, Papers p. 332
37. ^ Hardy & Wright, p. 337
38. ^ Mahler, K. On the fractional parts of the powers of a rational number II, 1957, Mathematika, 4, pages 122–124
39. ^ "C++ reference of floor function". Retrieved 5 December 2010.
40. ^ "C++ reference of ceil function". Retrieved 5 December 2010.
41. ^ dotnet-bot. "Math.Floor Method (System)". docs.microsoft.com. Retrieved 28 November 2019.
42. ^ dotnet-bot. "Math.Ceiling Method (System)". docs.microsoft.com. Retrieved 28 November 2019.
43. ^ "Math (Java SE 9 & JDK 9 )". docs.oracle.com. Retrieved 20 November 2018.
44. ^ "Math (Java SE 9 & JDK 9 )". docs.oracle.com. Retrieved 20 November 2018.
45. ^ "PHP manual for ceil function". Retrieved 18 July 2013.
46. ^ "PHP manual for floor function". Retrieved 18 July 2013.
47. ^
48. ^ "Python manual for math module". Retrieved 18 July 2013.
49. ^ Sullivan, p. 86.
50. ^ "Vocabulary". J Language. Retrieved 6 September 2011.
51. ^
52. ^ But the online help provided in 2010 does not reflect this behavior.