Working with 9-Estimating (Parts and Assemblies) > 9-5 Takeoffs > Formulas and Variables > Types of calculations you can perform in formulas
Types of calculations you can perform in formulas
Note: This functionality is available only if you have the Estimating Module.
You can perform the following basic mathematical operations: addition, subtraction, multiplication, division, calculating powers, and calculating square roots. When Sage 100 Contractor calculates a formula, it performs operations in parentheses first. Then Sage 100 Contractor calculates absolute values and square roots and powers, multiplication and division, and finally addition and subtraction.
| Use | Function | Expression | Result |
| + | Add | 21+53 | 74 |
| – | Subtract | 45–18 | 27 |
| * | Multiply | 5*8 | 40 |
| / | Divide | 72/9 | 8 |
| ^ | Calculate powers | 5^2 | 25 |
| ( ) | Calculate expressions in the parentheses prior to other expressions. | 4*(2+3) | 20 |
| SQR | Calculates the square root of the number enclosed in parentheses. | SQR(64) | 8 |
| ABS | Determines the absolute value of the number enclosed in parentheses. | ABS(–4) ABS(2) | 4 2 |
| |
More resources
For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.
For additional training on Sage products, visit Sage University.
