# Documentation/Calc Functions/ROUNDSIG

Jump to navigation
Jump to search

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

## Function name:

ROUNDSIG

## Category:

Mathematical

## Summary:

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

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

## Additional details:

None

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

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

NONE