Round a Formula's result
Formulas in iDoceo will let you calculate a column of results using any combination of:
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
And this is the original formula, a simple average between test1,test2 and test3
It works like this:
TRUNCF(NUMBEROFDECIMALS,YOURFORMULA)
The result with 0 decimal places will look like this
It looks like this:
ROUNDF(MODE,PRECISION,YOURFORMULA)
Here is a short table that will help you choose the right mode and precision
Our first example, Mode 3 (Round nearest), Precision 0 (unit)
Our second example, Mode 3 (Round nearest), Precision 5 (half points)
- Columns from any tab in your grade book
- Arithmetic operations
- Functions
- Conditions
- Constants
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 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)
