# 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 6 7 8 2 (Round down / Truncate) 4 5 6 7 3 (Round nearest) 4 5 7 8

 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