Translations:Documentation/Calc Functions/ROUNDSIG/19/en

From The Document Foundation Wiki
Jump to: navigation, search
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