📝 Note!
Enable the functions in one of the following ways:
Press the "Formulas" button in the menu, located in the very top of the Online Spreadsheet.
Insert the relevant function manually right in the cell.
Step-by-step guide for manual inserting of formulae:
Start with the “=” sign.
Insert the relevant function right after the “=” sign.
Insert the formulas itself in round brackets "( )"
Divide the values within a formula using the sign ","
Press the "Enter" button to get the result.
Thus, the formula will have the following look:
=min ( a1, c1)
Examples of formulas & functions currently supported in 2D Takeoff:
=max (a1, b1, c1)
=min (a1, b1, c1)
=average (a1, b1, c1)
=count (a1, b1, c1)
=round (x, y), where x is the cell's name / the value itself / another function / a mathematical expression, and y is a number showing the amount of decimal places, eg. round (3467263.77, -3)
= a1-c1
= a1+b1+c1
= a1*b1
= a1/b1
Helpful to remember:
The function's value can be either a reference to a cell / range of cells, or the value itself (number / measurement).
The formula is updated as soon as the cell used in this formula has been changed.
There’s no difference whether you insert the value starting from a capital letter or not.
Mathematical operations supported by Kreo can be used as the formula's argument. They are: addition, subtraction, multiplication, division, as well as the use of brackets.
Most common mistakes done in inserting formulas:
The formula's result will be "Invalid" in the following cases:
The argument contains the following values:
2 3 (a space is inserted)
B3 0.25 (a space is inserted)
3..33333 (2 dots are inserted)
Text is inserted. Exception: the Count option!
The argument is the link to the invalid cell.
The rules for inserting formulae were violated, eg. the sign "=" has not been used at the beginning.
The functions count/min/max/average/sum are used as the argument. In such a case you need to refer to the relevant cell with these calculations.
📝 Note!
Relative copying for formulas is also available in 2D Takeoff. You can easily copy a spreadsheet's cells together with all the data inside.
All formulas are being preserved while exporting to Excel and importing Excel files to the software.