Documentation/Calc Functions/ROUNDSIG

From The Document Foundation Wiki
Jump to: navigation, search
This page contains changes which are not marked for translation.

Other languages:
dansk • ‎English

Function name:

ROUNDSIG

Category:

Mathematical

Summary:

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

Syntax:

ROUNDSIG(Value; Digits)

Returns:

Returns a real number.

Arguments:

Value is a real number or a reference to the cell containing that number which is to be rounded.

Digits is a positive integer or a reference to the cell containing that integer which is the number of decimal places to round.

  • If Digits is not an integer but it is positive then the function uses its floor value, i.e. truncates it to integer.
  • If Digits is not greater than 0, the function returns an error value.

Additional details:

None

Examples:

Formula Description Returns
=ROUNDSIG(123.456789; 5) rounds 123.456789 to 5 significant decimal places 123.46
=ROUNDSIG(0.000123456789; 5) rounds 0.000123456789 to 5 significant decimal places 0.00012346
=ROUNDSIG(123456789012345; 2) rounds 123456789012345 to 2 significant decimal places to its normalised floating point notation 1.2E14
=ROUNDSIG(123456789; 4) rounds 123456789012345 to 2 significant decimal places to its normalised floating point notation 123500000 or 123.5E6

Related LibreOffice functions:

ROUND

MROUND

ROUNDUP

ROUNDDOWN

ODF standard:

None

Equivalent Excel functions:

NONE