Home : SROUNDZ
Q11287 - INFO: SROUNDZ
SROUNDZ A Spread formula that allows you to scientifically round values.  Handles values that contain data qualifiers (<,>,...).

SYNTAX:

SROUNDZ(Cell Reference/Value, Decimal Places)

Cell Reference/Value: The specifies the value to round.

Decimal Places: Sets the number of Decimal places to round to.

NOTES:

Scientific Rounding:  When the fractional part is exactly 0.5, the function always rounds it to the nearest even number.  For example, 0.5 rounds to 0, and 1.5 rounds to 2.  Normal rounding rounds digits 1,2,3, and 4 down.  Rounds digits 5,6,7,8, and 9 up.

You can only display up to 10 significant digits using this function.

In Spread Reports if you want to use normal rounding, simply set the decimal places by using the Increase/Decrease decimal buttons or use Format, Cell. 

See Scientific vs Normal rounding for a table showing the key differences between the rounding techniques.

See SROUND to round numbers without qualifiers. 

EXAMPLES:

=SROUNDZ("<2.5", 0) <2

=SROUNDZ(GAVGZ(1,1,"M",1, 2),1) <3.1 (where GAVGZ returns "<3.11")

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/2/2008 1:36 PM.
Last Modified on 8/13/2018 11:06 AM.
Last Modified by Scott Dorner.
Article has been viewed 1547 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article