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.
