Round a Formula's result

Formulas in iDoceo will let you calculate a column of results using any combination of:

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

And this is the original formula, a simple average between test1,test2 and test3

Removing decimals: Truncate function

The truncate function will let you specify the number of decimal places you want, if any.
It works like this:
TRUNCF(NUMBEROFDECIMALS,YOURFORMULA)

The result with 0 decimal places will look like this

Rounding function

The rounding function will let you choose the kind of rounding and its precision.
It looks like this: ROUNDF(MODE,PRECISION,YOURFORMULA)

Here is a short table that will help you choose the right mode and precision

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