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 |