Documentation/Calc Functions/ROUNDSIG

Other languages:

ROUNDSIG

Mathematical

Summary:

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

 Note: This function is available since LibreOfficeDev 5.4.

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 supposed 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 floor value, i.e. truncates it to integer.
• If Digits is not greater than 0, the function returns an error value.

 Warning: Digits must be an integer greater than 0.

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

ROUND

MROUND

ROUNDUP

ROUNDDOWN

None

NONE