# ⨐ Formulas in Join

Join allows you to perform calculations by entering a formula in a Join data grid, such as the Milestone Estimate and Budget and Items. Formulas can be added to any editable numerical cell, such as unit price or quantity.

#### Creating a formula

• Double click a numerical value cell
• Type the equal sign =
• Enter the formula you want to calculate e.g. 2*5
• Press Enter
• The result of the calculation will appear in cell  #### Referencing other cells

Within a formula, you can reference numerical cells in other columns and rows within the same table using the following syntax [Line Number].[Column] e.g. L10.Quantity  If using the detailed cost type breakdown, you can reference cells under each cost breakdown by including the breakdown name e.g. L10.Material.Unit Price. Note: Cell references should include spaces for columns such as Unit Price

#### Supported Operations

 Arithmetic operators Meaning Example + (plus sign) Addition =3+3 – (minus sign) Subtraction Negation =3-3 =-3 * (asterisk) Multiplication =3*3 / (forward slash) Division =3/3 % (percent sign) Percent 30% ^ (caret) Exponentiation =3^3

#### Correcting errors in formulas

If your formula isn’t accepted or contains an error, you will see a red ! in the cell, hover over this to get a detailed explanation of the error. 