Enter formulas in Join Milestone and Item estimate tables to calculate values. 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 the cell.
Note: Cells containing formulas will display an underlined value.
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., =L5.Quantity*10
If using the detailed cost type breakdown, you can reference cells under each cost breakdown by including the breakdown name. e.g., L5.Labor.Unit Price.
Caution: Column references should include spaces for column names such as "Unit Price".
Caution: Row references are case-sensitive but column references are not. Use "L10", not "l10" for row references. Use either "Quantity" or "quantity" for column references.
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 an Error 
icon in the cell, hover over this icon to get a detailed explanation of the error.
