# Documentation/Calc Functions/ROUNDSIG

Other languages:
dansk • ‎English

ROUNDSIG

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.

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

ROUND

MROUND

ROUNDUP

ROUNDDOWN

None

NONE