Q11325 - INFO: SFR

SFR formats the value to significant figures (digits) as specified.

SYNTAX:

SFR(Value,SignificantDigits,MaxDecPlaces,RoundType)

Value:  Value to be formatted.  Can be value, cell reference, or another function.

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.

EXAMPLES:

 Value Formula Result 124.2000 SFR(B3,3,3,1) 124 5.7766 SFR(B4,3,3,1) 5.78 4.6662 SFR(B5,3,1,1) 4.7 24.5000 SFR(B6,2,3,1) 24 28 SFR(B6,3,3,1) 28.0 28.5000 SFR(B7,3,3,2) 28.5 12 SFR(B8,3,5) 12.0 0.001 SFR(B8,3,5) 0.00100 12345 SFR(B8,3,5) 12300 0 SFR(B8,3,5) 0 0.00 SFR(B8,3,5) 0 3.0447 SFR(B7,4,2,2) 3.05

Why was the last one 3.05? Examining our formula we see we wanted 4 significant digits, therefore the function narrows our number from 3.0447 to 3.045 first. Then the function rounds 3.045 by rule #2 to 2 decimal places - giving us 3.05.

 Related Articles No Related Articles Available.

 Article Attachments No Attachments Available.