Floor and ceiling functions

For other uses, see Floor (disambiguation) and Ceiling (disambiguation).

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 $\operatorname {floor} (x)$ or $\lfloor x\rfloor$. Similarly, the ceiling function maps $x$ to the least integer greater than or equal to $x$, denoted $\operatorname {ceil} (x)$ or $\lceil x\rceil$.

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

The integral part or integer part of x, often denoted $[x],$ is $\lfloor x\rfloor$ if x is nonnegative, and $\lceil x\rceil$ otherwise. In words, this is the closest integer to x that has the largest absolute value less than or equal to the absolute value of x.

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 $[x]$ in his third proof of quadratic reciprocity (1808). This remained the standard in mathematics until Kenneth E. Iverson introduced, in his 1962 book A Programming Language, the names "floor" and "ceiling" and the corresponding notations $\lfloor x\rfloor$ and $\lceil x\rceil$. Both notations are now used in mathematics, although Iverson's notation will be followed in this article.

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

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

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

For all x,

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

Examples

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

• U+2308 ⌈ LEFT CEILING (&lceil;, &LeftCeiling;)
• U+2309 ⌉ RIGHT CEILING (&rceil;, &RightCeiling;)
• U+230A ⌊ LEFT FLOOR (&LeftFloor;, &lfloor;)
• U+230B ⌋ RIGHT FLOOR (&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 $\mathbb {Z}$, floor and ceiling may be defined by the equations

$\lfloor x\rfloor =\max\{m\in \mathbb {Z} \mid m\leq x\},$

$\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

$x-1<m\leq x\leq n<x+1.$

where $\lfloor x\rfloor =m$ and $\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.

${\begin{aligned}\lfloor x\rfloor =m&\;\;{\mbox{ if and only if }}&m&\leq x<m+1,\\\lceil x\rceil =n&\;\;{\mbox{ if and only if }}&n-1&<x\leq n,\\\lfloor x\rfloor =m&\;\;{\mbox{ if and only if }}&x-1&<m\leq x,\\\lceil x\rceil =n&\;\;{\mbox{ if and only if }}&x&\leq n<x+1.\end{aligned}}$

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.

${\begin{aligned}x<n&\;\;{\mbox{ if and only if }}&\lfloor x\rfloor &<n,\\n<x&\;\;{\mbox{ if and only if }}&n&<\lceil x\rceil ,\\x\leq n&\;\;{\mbox{ if and only if }}&\lceil x\rceil &\leq n,\\n\leq x&\;\;{\mbox{ if and only if }}&n&\leq \lfloor x\rfloor .\end{aligned}}$

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

${\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:

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

$\lfloor x\rfloor \leq \lceil x\rceil ,$   with equality if and only if x is an integer, i.e.

$\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:

$\lfloor n\rfloor =\lceil n\rceil =n.$

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

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

and:

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

$\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:

$\{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:

${\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:

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

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

If n is a positive integer

$\left\lfloor {\frac {x+m}{n}}\right\rfloor =\left\lfloor {\frac {\lfloor x\rfloor +m}{n}}\right\rfloor ,$

$\left\lceil {\frac {x+m}{n}}\right\rceil =\left\lceil {\frac {\lceil x\rceil +m}{n}}\right\rceil .$

If m is positive

$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 ,$

$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

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

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

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

$\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)

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

$\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:

$\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

$\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

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

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

Nested divisions

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

$\left\lfloor {\frac {\lfloor x/m\rfloor }{n}}\right\rfloor =\left\lfloor {\frac {x}{mn}}\right\rfloor$

$\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 $\lfloor x\rfloor$, $\lceil x\rceil$, and $\{x\}$ have discontinuities at the integers.

$\lfloor x\rfloor$  is upper semi-continuous and  $\lceil x\rceil$  and $\{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

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

$\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

$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,

$0\leq x{\bmod {y}}<y,$

and if y is negative,

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

Quadratic reciprocity

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

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

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

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

$\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

$\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

$\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

$\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:

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

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

Rounding

For an arbitrary real number $x$, rounding $x$ to the nearest integer with tie breaking towards positive infinity is given by ${\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 ${\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 ${\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 $\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 ${\text{rpi}}(x)$ minus an integrality indicator for ${\tfrac {2x-1}{4}}$.

Truncation

The truncation of a positive number is given by $\lfloor x\rfloor .$ The truncation of a negative number is given by $\lceil x\rceil$. Obviously the truncation of $0$ is itself $0$.

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

Number of digits

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

$\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

$\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 $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 p^k > 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.

Euler's constant (γ)

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

$\gamma =\int _{1}^{\infty }\left({1 \over \lfloor x\rfloor }-{1 \over x}\right)\,dx,$

$\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

$\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)+\dots$

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) that if $\phi (x)$ is any function with a continuous derivative in the closed interval [a, b],

$\sum _{a<n\leq b}\phi (n)=\int _{a}^{b}\phi (x)\,dx+\int _{a}^{b}\left(\{x\}-{\tfrac {1}{2}}\right)\phi '(x)\,dx+\left(\{a\}-{\tfrac {1}{2}}\right)\phi (a)-\left(\{b\}-{\tfrac {1}{2}}\right)\phi (b).$

Letting $\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

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

For s = σ + it in the critical strip 0 < σ < 1,

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

Formulas for prime numbers

The floor function appears in several formulas characterizing prime numbers. For example, since $\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

$\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 p_n be the n^th prime, and for any integer r > 1, define the real number α by the sum

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

Then

$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

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

are all prime.

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

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

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

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

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

Solved problems

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

If n is a positive integer, prove that

(i)     $\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)     $\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)     $\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

$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 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.

A bit-wise right-shift of a signed integer $x$ by $n$ is the same as $\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.

Many programming languages (including C, C++, C#, Java, PHP, R, and Python) provide standard functions for floor and ceiling, usually called floor and ceil, or less commonly ceiling. 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. ALGOL usesentier for floor.

Spreadsheet software

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. This has followed through to the Office Open XML file format. Excel 2010 now follows the standard definition.

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.

See also

• Bracket (mathematics)
• Integer-valued function
• Step function

References

• J.W.S. Cassels (1957), An introduction to Diophantine approximation, Cambridge Tracts in Mathematics and Mathematical Physics, vol. 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

External links

• "Floor function", Encyclopedia of Mathematics, EMS Press, 2001 [1994]
• Štefan Porubský, "Integer rounding functions", Interactive Information Portal for Algorithmic Mathematics, Institute of Computer Science of the Czech Academy of Sciences, Prague, Czech Republic, retrieved 24 October 2008
• Weisstein, Eric W. "Floor Function". MathWorld.
• Weisstein, Eric W. "Ceiling Function". MathWorld.