# Documentation/Calc Functions/ROUNDSIG

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

## 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.

- Make sure that the number of displayed decimal places is not affected by the setting of the

## 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:

## ODF standard:

None.

## Related (or similar) Excel functions:

None.