**π 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.