- Columns from any tab in your grade book
- Arithmetic operations
It is a very powerful system with unlimited possibilites and combinations
In this article we will explain how to round the result of a calculation.
Formulas do not take into account the grade type property of a column since they offer a wider range of options and functions.
Here is our sample data
Removing decimals: Truncate functionThe truncate function will let you specify the number of decimal places you want, if any.
It works like this:
Rounding functionThe rounding function will let you choose the kind of rounding and its precision.
It looks like this:
|Mode / Example||4.1||5.4||6.5||7.7|
|1 (Round up)||5.0||6.0||7.0||8.0|
|2 (Round down / Truncate)||4.0||5.0||6.0||7.0|
|3 (Round nearest)||4.0||5.0||7.0||8.0|
|5 (half points)||0.5|
|6 (quarter points)||0.25|
Our first example, Mode 3 (Round nearest), Precision 0 (unit)
Our second example, Mode 3 (Round nearest), Precision 5 (half points)