From The Document Foundation Wiki
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
|