Home : SROUND
Q10892 - INFO: SROUND

SROUND Scientific Rounding. When the fractional part of a number 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.

SYNTAX:

SROUND(Cx or Exp, DecimalPlaces)
where :
Cx is a conditional variable x
Exp is a Expression
Decimal Places specifies the number of places after the decial to round the number

NOTES:

If Decimal Places is negative, it will round number to the left of the decimal point.

See also ROUND for standard rounding and SDIGITS significant digits rounding.

EXAMPLES:

V132 = SROUND(C70,0)

In this example, variable 132 will contain the values from variable 70 rounded using the Scientific Rounding method described above:
(Note: The ROUND function's results have been included in the middle column for comparison)

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 4/10/2008 2:00 PM.
Last Modified on 4/10/2008 2:00 PM.
Last Modified by No Author Name Available!.
Article has been viewed 2834 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article