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 |
