Documentation/Calc Functions/ROUNDSIG

    From The Document Foundation Wiki
    Other languages:


    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:
    1. 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 Tools ▸ Options ▸ LibreOffice Calc ▸ Calculate dialog (LibreOffice ▸ Preferences ▸ LibreOffice Calc ▸ Calculate on macOS).
    2. Access the Numbers tab on the Format Cells dialog (Format ▸ Cells or equivalent interaction) to make sure that relevant cells do not have formatting applied that affects the number of displayed decimal places.

    Examples:

    Formula Description Returns
    =ROUNDSIG(123.456789; 5) Here the function rounds 123.456789 to 5 significant digits. 123.46 or 1.2346E2
    =ROUNDSIG(D1; D2) where cells D1 and D2 contain the numbers -0.000123456789 and 5 respectively. Here the function rounds -0.000123456789 to 5 significant digits. -0.00012346 or -1.2346E-4
    =ROUNDSIG(123456789012345; 2) Here the function rounds 123456789012345 to 2 significant digits. 120000000000000 or 1.2E14
    =ROUNDSIG(123456789; 4.678) The value of the Digits argument is truncated to 4. Here the function rounds 123456789 to 4 significant digits. 123500000 or 1.235E8

    Related LibreOffice functions:

    MROUND

    ROUND

    ROUNDDOWN

    ROUNDUP

    ODF standard:

    None.

    Related (or similar) Excel functions:

    None.