Home : Rounding
Q11158 - INFO: Rounding

Used to format spread report cells using scientific or significant digit rounding.   Spread uses "normal" rounding by default.  This form can be used to override the default.

USING:

Select the type of rounding (Scientific or Significant Digit), set the decimal places/significant digits and click .  The selected cells will be formatted using the SROUND (Scientific Rounding), SFR (Significant Figure Rounding), or SFRZ (Sgnificant Figure Rounding including MDL Symbol) functions as specfied.


FIELDS:


Scientific Rounding To: Check this box to perform scientific rounding on the selected cells to the number of decimal places specified.  Uses the SROUNDfunction.

Significant Digits:  Check this box to perform significant digit (figure) rounding on the selected cells to the number of significant digits specfied.  Uses the SFR or SFRZ function.


See Also: Round - Spread Function for Normal Rounding

 

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 5/8/2008 1:39 PM.
Last Modified on 8/28/2008 1:21 PM.
Last Modified by Scott Dorner.
Article has been viewed 2514 times.
Rated 4 out of 10 based on 2 votes.
Print Article
Email Article