Filemaker Pro 9 (105)

Question 1

This set entered on 7-21-14
7.26154.6

1. FileMaker uses standard mathematical rules to decide in what order to evaluate things. What is this order?

Answer 1

First EXPONENTIATION, then MULTIPLICATION/ DIVISION, then lastly ADDITION/SUBTRACTION.

Question 2

2. If you want FileMaker to do part of your calc FIRST, then:

Answer 2

put it in parenthesis. In the calc 4 + 3 * 2, 3 and 2 are multiplied before adding 4. In (4 + 3) * 2, 4 + 3 are added FIRST, and then multiplied by 2

Question 3

3. In this calc, the interest is calculated on the sum of the balance and service charge: (Balance Due + Service Charge ) * Interest Rate.

Answer 3

Without parenthesis, FileMaker would calculate the interest on only the service charge and then add that to the balance due, with an entirely different result.