Home : SDIGITS
Q10661 - INFO: SDIGITS

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.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/24/2008 5:50 PM.
Last Modified on 2/27/2020 2:44 PM.
Last Modified by Scott Dorner.
Article has been viewed 2879 times.
Rated 4 out of 10 based on 6 votes.
Print Article
Email Article