Ceiling functions

CEILING

Rounds a number to the nearest multiple of a significance value.

For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs.

warning

If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that has existed since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions.


Sintaxis

CEILING(Number [; Significance [; Mode]])

Number is the number that is to be rounded, or a reference to a cell containing the number.

Significance (optional) is the value, or a reference to a cell containing the value, to whose multiple Number is to be rounded. It defaults to +1 or -1 depending on the sign of Number.

Mode (optional) is a number, or a reference to a cell containing a number. The function only uses Mode if both Number and Significance are negative. Then if Mode is given and not equal to zero, numbers are rounded down (away from zero); if Mode is equal to zero or not given, negative numbers are rounded up (towards zero).

Ejemplo

=MULTIPLO.SUPERIOR(3,45) devuelve 4.

=CEILING(3.45; 3) returns 6.

=MULTIPLO.SUPERIOR(-1,234) devuelve −1.

=CEILING(-45.67; -2; 0) returns -44.

=CEILING(-45.67; -2; 1) returns -46.

CEILING.PRECISE

Rounds a number up to the nearest multiple of a significance value.

For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.

note

This function calculates identical results to the ISO.CEILING function.


tip

Esta función está disponible desde la versión 4.3 de LibreOffice


Sintaxis

CEILING.PRECISE(Number [; Significance])

Number is the number that is to be rounded, or a reference to a cell containing the number.

Significance (optional) is the value, or a reference to a cell containing the value, to whose multiple Number is to be rounded. It defaults to 1.

Ejemplo

=CEILING.PRECISE(3.45) returns 4.

=CEILING.PRECISE(-45.67; 2) returns -44.

CEILING.MATH

Rounds a number to the nearest multiple of a significance value.

For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored.

tip

Esta función está disponible desde la versión 5.0 de LibreOffice.


warning

This function exists for interoperability with Microsoft Excel 2013 or newer.


Sintaxis

CEILING.MATH(Number [; Significance [; Mode]])

Number is the number that is to be rounded, or a reference to a cell containing the number.

Significance (optional) is the value, or a reference to a cell containing the value, to whose multiple Number is to be rounded. It defaults to 1.

Mode (optional) is a number, or a reference to a cell containing a number. If Mode is given and not equal to zero, a negative Number is rounded down (away from zero). If Mode is equal to zero or is not given, a negative Number is rounded up (towards zero).

Ejemplo

=CEILING.MATH(3.45) returns 4.

=CEILING.MATH(3.45; -3) returns 6.

=CEILING.MATH(-1.234) returns -1.

=CEILING.MATH(-45.67; -2; 0) returns -44.

=CEILING.MATH(-45.67; +2; 1) returns -46.

MULTIPLO.SUPERIOR.XCL

Redondea un número al múltiplo de la precisión más próximo.

En el caso de un número y una precisión positivos, la función redondea al alza (alejándose del cero). Para números negativos y precisiones positivas, la dirección de redondeo es al alza (aproximándose al cero). Si tanto el número como la precisión son negativos, la función redondea a la baja (alejándose del cero). La función devuelve un error y el número es positivo y la precisión, negativa.

tip

Esta función está disponible desde la versión 5.0 de LibreOffice.


warning

Esta función existe para la interoperatividad con Microsoft Excel 2007 o versiones anteriores. Si un libro de Calc se exporta a Microsoft Excel, las referencias a la función MULTIPLO.SUPERIOR.XCL de Calc se exportan como referencias a la función MULTIPLO.SUPERIOR de Excel, la cual es compatible con todas las versiones de Excel. De la misma manera, si se importa un libro de Excel en Calc, las referencias a la función MULTIPLO.SUPERIOR de Excel se importan como referencias a la función MULTIPLO.SUPERIOR.XCL de Calc.


Sintaxis

MULTIPLO.SUPERIOR.XCL(Número; Precisión)

Number is the number that is to be rounded, or a reference to a cell containing the number.

Precisión es el valor, o bien, la referencia a una celda que contiene el valor, a cuyo múltiplo el Número debe redondearse.

Ejemplo

=MULTIPLO.SUPERIOR.XCL(3,45;2) devuelve 4.

=CEILING.XCL(-45.67; 2) returns -44.

=CEILING.XCL(-45.67; -2) returns -46.

ISO.CEILING

Rounds a number up to the nearest multiple of a significance value.

For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.

note

Esta función calcula los resultados de idéntica manera a la función MULTIPLO.SUPERIOR.EXACTO.


Sintaxis

ISO.CEILING(Number [; Significance])

Number is the number that is to be rounded, or a reference to a cell containing the number.

Significance (optional) is the value, or a reference to a cell containing the value, to whose multiple Number is to be rounded. It defaults to 1.

Ejemplo

=ISO.CEILING(3.45) returns 4.

=ISO.CEILING(-45.67; 2) returns -44.

¡Necesitamos su ayuda!