Computer implementations

Spreadsheet software

This commodity needs added citations for verification. Please advice advance this commodity by abacus citations to reliable sources. Unsourced actual may be challenged and removed. (August 2008)

Most spreadsheet programs abutment some anatomy of a beam function. Although the data alter amid programs, a lot of implementations abutment a additional parameter—a assorted of which the accustomed amount is to be angled to. For example, ceiling(2, 3) circuit 2 up to the abutting assorted of 3, giving 3. The analogue of what "round up" means, however, differs from affairs to program.

Until Excel 2010, Microsoft Excel's beam action was incorrect for abrogating arguments; ceiling(-4.5) was -5. . This has followed through to the Office Open XML book format. The actual beam action can be implemented application "-INT(-value)". Excel 2010 now follows the accepted definition.38

The OpenDocument book format, as acclimated by OpenOffice.org and others, follows the algebraic analogue of beam for its beam function, with an alternative constant for Excel compatibility. For example, CEILING(-4.5) allotment −4.

editTypesetting

The attic and beam action are usually typeset with larboard and appropriate aboveboard brackets area the high (for attic function) or lower (for beam function) accumbent confined are missing, and, e.g., in the LaTeX book arrangement these symbols can be defined with the \lfloor, \rfloor, \lceil and \rceil commands in algebraic mode. HTML 4.0 uses the aforementioned names: ⌊, ⌋, ⌈, and ⌉. Unicode contains codepoints for these symbols at U+2308–U+230B: ⌈x⌉, ⌊x⌋.