SFRZ formats the value to significant figures (digits) as specified.
SYNTAX:
SFRZ(Value,SignificantDigits,MaxDecPlaces,RoundType)
Value: Value to be formatted. Can be value, cell reference, or another function. Value can include symbols ("<",">").
SignificantDigits: Number of Significant Figures (Digits)
MaxDecPlaces Maximum number of Decimal Places.
RoundType Sets rounding type. See Scientific vs Normal Rounding for more info on rounding. Valid settings are:
1 - Scientific
2 - Normal
3 - Truncate
NOTES:
This function can be placed by using the Format, Rounding menu option. 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, SFR, DPC
EXAMPLES:
Value |
Formula |
Result |
124.2000 |
SFRZ(STR(B3),3,3,1) |
124 |
<5.7766 |
SFRZ(STR(B4),3,3,1) |
<5.78 |
<0.00162 |
SFRZ(STR(B5),2,7,1) |
<0.0016 |
24.5000 |
SFRZ(STR(B6),2,3,1) |
24 |
28.5000 |
SFRZ(STR(B7),2,3,2) |
29 |