ROUNDSIG

Returns a number rounded to a specified number of significant decimal digits of its normalized floating point notation.

Sintaxi

ROUNDSIG( Value; Digits )

Value: the number to be rounded.

Digits: the number of decimal places to round.

Digits must be an integer greater than 0.

Exemples

=ROUNDSIG(123.456789; 5) returns 123.46.

=ROUNDSIG(0.000123456789; 5) returns 0.00012346

=ROUNDSIG(123456789012345; 2) returns 1.2E14

=ROUNDSIG(123456789; 4) returns 123500000 or 123.5E6

Informació tècnica

Aquesta funció és disponible des de la versió 5.4 del LibreOffice.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

ORG.LIBREOFFICE.ROUNDSIG

ROUNDSIG wiki page.

See also ROUND, MROUND, ROUNDUP, ROUNDDOWN.