All Collections
Spreadsheet
Formulas and functions
Available formulas and functions
Available formulas and functions

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

Karolina Pavlova avatar
Written by Karolina Pavlova
Updated over a week ago

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 to learn the rules for working with formulas and functions.


​

Did this answer your question?