SDIGITS Formats the value to a specified significant figures (digits)
SYNTAX:
SDIGITS(Vx,Significant Digits)
where :
Vx is a variable x
Significant Digits is the number of significant digits to display.
EXAMPLES:
| V1 |
Formula |
Result |
| 124.2000 |
SDIGITS(V1,3) |
124 |
| 5.7766 |
SDIGITS(V1,3) |
5.78 |
| 4.6662 |
SDIGITS(V1,2) |
4.7 |
| 24.5000 |
SDIGITS(V1,2) |
25 |
| 28.172000 |
SDIGITS(V1*2,3) |
56.3 (28.172 * 2 = 56.344) |
NOTES: SDIGITS uses normal rounding. See Normal vs Scientific Rounding.