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

Links to more information . . .

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.