iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here

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
    21 AUG

    iDoceo 7 for iPad and Mac now available!

    A huge update with tons of new features and a new interface

    Read more

    6 JUN

    Create Multiple-choice tests with iDoceo Connect!

    In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

    Read more

    Cookies policy

    This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.