Documentation/Calc Functions/ROUNDSIG

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

Calc Functions Home | List of functions | Abbreviations

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.