Documentation/Calc Functions/ROUNDSIG

Function name:
ROUNDSIG

Category:
Mathematical

Summary:
Rounds a number to a specified number of significant decimal digits of its normalized floating-point notation.

Syntax:
ROUNDSIG(Value; Digits)

Returns:
Returns a real value which is the specified number rounded to the given number of significant digits.

Arguments:
Value is a real number, or a reference to a cell containing that number, that is to be rounded.

Digits is a positive integer, or a reference to a cell containing that integer, that is the required number of significant digits.


 * If either Value or Digits are non-numeric, then ROUNDSIG reports a #VALUE! error.
 * If Digits is a non-integer value, then ROUNDSIG converts it to an integer by taking its floor value.
 * If Digits is less that 1, then ROUNDSIG reports an invalid argument error (Err:502).

Additional details:

 * For more background information relating to the ROUNDSIG function, visit Wikipedia’s Significant figures and Normalized number pages.


 * If you obtain unexpected results from ROUNDSIG, check the following:
 * Make sure that the number of displayed decimal places is not affected by the setting of the Limit decimals for general number format option in the General Calculations area of the dialog ( on macOS).
 * Access the tab on the Format Cells dialog ( or equivalent interaction) to make sure that relevant cells do not have formatting applied that affects the number of displayed decimal places.

Related LibreOffice functions:
MROUND

ROUND

ROUNDDOWN

ROUNDUP

ODF standard:
None.

Equivalent Excel functions:
None.