The floor function, sometimes called the greatest integer function, of a real number x, denoted variously by x[2], floor(x), or int(x)[3][4], is a function whose value is the largest integer less than or equal to x. Formally, for all real numbers x,
For example, floor(2.9) = 2, floor(−2) = −2 and floor(−12/5) = −3. For nonnegativex, a more traditional name for floor(x) is the integral part or integral value of x. The function , also written as xmod 1, or {x}, is called the fractional part of x. Every fractionx can be written as a mixed number, the sum of an integer and a proper fraction. The floor function and fractional part functions extend this decomposition to all real values.
The closely-related ceiling function, denoted or ceil(x) or ceiling(x), is the function whose value is the smallest integer not less than x, or, formally,
For example, ceiling(2.3) = 3, ceiling(2) = 2 and ceiling(−12/5) = −2.
The names "floor" and "ceiling" and the corresponding notations were introduced by Kenneth E. Iverson in 1962.[5][6]
If x is a real number and n is an integer, one has n ≤ xif and only ifn ≤ floor(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.
Using the floor function, one can produce several explicit (yet impractical) formulas for prime numbers.
For real, non-integer x, the floor function has the Fourier series representation
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. As a typical example, ceiling(2, 3) would round 2 up to the nearest multiple of 3, so this would return 3. The definition of what "round up" means, however, differs from program to program.
Microsoft Excel's ceiling function does not follow the mathematical definition, but rather as with (int) operator in C, it is a mixture of the floor and ceiling function: for x ≥ 0 it returns ceiling(x), and for x < 0 it returns floor(x). This has followed through to the Office Open XML file format. For example, CEILING(-4.5) returns -5. A mathematical ceiling function can be emulated in Excel by using the formula "-INT(-value)" (please note that this is not a general rule, as it depends on Excel's INT function, which behaves differently that most programming languages).
The OpenDocument file format, as used by OpenOffice.org 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.
Typesetting
The floor and ceiling function 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. Unicode contains codepoints for these symbols, at U+2308–U+230B: ⌈x⌉, ⌊x⌋.
^ ,J.W.S. Cassels (1957). An introduction to Diophantine approximation, Cambridge Tracts in Mathematics and Mathematical Physics 45. Cambridge University Press, 1.
^ Michael Sullivan. Precalculus, 8th edition, p. 86