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](/images/idoceo7/formula_functions_01.jpg)
- Max value This function returns the maximum grade for grades across multiple columns.
- Example of how to use it
![idoceo formulas](/images/idoceo7/formula_functions_02.jpg)
- Result:
![idoceo formulas](/images/idoceo7/formula_functions_03.jpg)
- 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.
- Flexible Average This function returns the average grade of the grades between several columns avoiding empty cells.
- Example of use:
![idoceo formulas](/images/idoceo7/formula_functions_04.jpg)
- Result:
![idoceo formulas](/images/idoceo7/formula_functions_05.jpg)
Related articles
Rounding a Formula's result
Formulas: IF condition
Formulas, apply limits to results
Your first Formula
Formula Functions: Averages