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


Our first example, Mode 3 (Round nearest), Precision 0 (unit)





Our second example, Mode 3 (Round nearest), Precision 5 (half points)



Related articles

Your first Formula