- Columns from any tab in your grade book
- Arithmetic operations
- Functions
- Conditions
- Constants
Here is how we add a formula in our gradebook: Add Calculation > Formula

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.
First we will add a formula to our gradebook, a simple average, just like that:

Here is the calculation result of our sample data


Removing decimals: Truncate function
The truncate function will let you specify the number of decimal places you want, if any.It works like this:


Rounding function
The 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 |
Precision | Example |
0 (units) | 92 |
1 (0.1) | 0.8 |
2 (0.01) | 0.06 |
3 (0.001) | 0.006 |
4 (0.0001) | 0.0003 |
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)

