Home : SFRZ
Q11326 - INFO: SFRZ

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

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 6/5/2008 11:52 AM.
Last Modified on 1/25/2016 1:28 PM.
Last Modified by Scott Dorner.
Article has been viewed 5041 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article