---
title: "Available formulas and functions"
description: "Add formulas and use the built-in functions to perform calculations and solve current problems in the most efficient way"
url: https://help-takeoff.kreo.net/en/articles/5488007-available-formulas-and-functions
collection: "Formulas and functions"
updated: 2026-08-16
language: en
alternates: [fr]
---

# Available formulas and functions

Add formulas and use the built-in functions to perform calculations and solve current problems in the most efficient way

Currently, Kreo 2D Takeoff supports the following functions in the schedule:

-   **_Max_** - searching for the maximum value out of several
    
-   **_Min_** - searching for the minimum value out of several
    
-   **_Average_** - calculating the average value for a range of values
    
-   **_Sum_** - calculating the sum of several values
    
-   **_Count_** - calculating the amount of elements which contain numeric values
    
-   **_Round_** - rounding a value to a certain decimal point
    
-   **_Addition_** - adding one value to another
    
-   **_Subtraction_** - subtracting one value from another
    
-   **_Multiplication_** - multiplying one value by another
    
-   **_Division_** - dividing one value by another
    

📝 **Note!**

Enable the functions in one of the following ways:

1.  Press the "Formulas" button in the **menu**, located at the very top of the Online Spreadsheet.  
    \*\*This option doesn't work for the **addition;** **subtraction; multiplication & division** functions. These functions can be enabled only by inserting the functions and values manually into the cell.  
    _Examples_:  
    \= a1+b1  
    \= a1-b1  
    \= a1\*b1  
    \= a1/b1
    
2.  Insert the relevant function manually right into the cell. [Click here](https://help-takeoff.kreo.net/en/articles/5488015-rules-for-working-with-formulas-and-functions.md) to learn the rules for working with formulas and functions.
    

  
​