Home : SFC
Q14357 - INFO: SFC
 SFC returns the number of significant figures (digits) for the given value.

SYNTAX:

SFC(Value)

Value:  Value to be evaluated.  Can be numeric value,text, cell reference, or another function.

NOTES:

Rules for significant figures:

  • Digits from 1-9 are always significant.
  • Zeros between two other significant digits are always significant
  • One or more additional zeros to the right of both the decimal place and another significant digit are significant.
  • Zeros used solely for spacing the decimal point (placeholders) are not significant.

SEE ALSO: GPREC, GDP, SFRZ, SFR, DPC

EXAMPLES:

Value Formula Result
124.2000 SFC(B3)  7
5.7 SFC(B4)  2
<0.1234 SFR(B5)  4
<0.00100 SFR(B6,3,3,1) 3
<0.00100 CONCAT(QUALIFIER(E4),SFRZ(STR(VAL($B4)/1000,SFC(B4),9,1)) <0.00000100

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/25/2016 1:05 PM.
Last Modified on 1/25/2016 1:18 PM.
Last Modified by Scott Dorner.
Article has been viewed 1180 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article