Home : Normal vs Scientific Rounding
Q11286 - INFO: Normal vs Scientific Rounding

Difference between Normal and Scientific Rounding

  • Normal Rounds digits 1,2,3, and 4 down.  Rounds digits 5,6,7,8, and 9 up. 
  • Scientific Rounds digits 1,2,3, and 4 down. Rounds digiits 6,7, 8, and 9 up.  Rounds 5 to the nearest even number.

Value     Normal (to zero decimal places) Scientific    
1.5 2 2
2.5 3 2
4.2 4 4
4.7 5 5

 

In spread reports by default we use normal rounding.  For example, if you specify that the cell should be displayed to 1 decimal, it will use normal rounding and display the number to 1 decimal (However, the cells value is still to the full decimal places of the original value).  If you want to use Scientific Rounding you need to use the SROUND,SFR, or SFRZ functions.

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:29 PM.
Last Modified on 10/9/2012 4:46 PM.
Last Modified by Scott Dorner.
Article has been viewed 28283 times.
Rated 5 out of 10 based on 33 votes.
Print Article
Email Article