Formulas: How to use its functions

Basic functions of iDoceo formulas

When you create a calculation column of the formula type, you can access the preprogrammed functions by pressing the Functions button

idoceo formulas



    • Max value
    • This function returns the maximum grade for grades across multiple columns.



      Example of how to use it



idoceo formulas



      Result:



idoceo formulas



    • Min value
    • This function returns the minimum grade for grades between multiple columns.



      Its use is similar to that of the previous function.



    • Condition
    • When you want to carry out a series of calculations or give a result only in case a condition is met, you must use this function.



Find here how to use it



    • Flexible Average
    • This function returns the average grade of the grades between several columns avoiding empty cells.



      Example of use:



idoceo formulas



      Result:



idoceo formulas



Related articles

Rounding a Formula's result
Formulas: IF condition
Formulas, apply limits to results
Your first Formula
Formula Functions: Averages