Brother International WP335B Owners Manual - English - Page 207

Order

of

Calculation

of

a

Formula

Calculation

of

a

formula

is

performed

in

the

order

of

precedence

of

the

operators:

the

+

or

—

sign

is

first

attributed

to

the

operand

directly

to

the

sign's

right,

exponentiations

are

carried

out

next,

then

multiplication

and

divisions,

and

finally,

additions

and

subtractions.

Example

1:

2#3

*4-2

8x4-2

32-2

30

When

two

or

more

operators

have

the

same

order

of

precedence

(multiplication

and

divisions,

or

addition

and

subtraction),

calculation

is

carried

out

from

left

to

right.

Example

2:

1+3+4-2

2#3#2

4+4-2

8#2

8-2

64

6

Use

parentheses

to

change

the

order

of

mathematical

operations.

The

formula

in

parentheses

is

calculated

first.

Example

3:

1+3*4

(1+3)

*4

1+12

4*4

13

16

Parentheses

can

be

nested.

Calculation

proceeds

from

the

innermost

pair

of

parentheses.

Example

4:

((3

*4+1) *4+3)

*4-12

(13

*4+3)

*4-12

55*4-12

220-12

208

NOTES:

•

Up

to

6

pairs

of

parentheses

can

be

nested.

Using

more

than

6

pairs

of

nested

parentheses

makes

the

formula

invalid.

The

formula

is

also

invalid

if

parentheses

do

not

come

in

pairs.

•

Parentheses

can

be

used

for

the

simple

purpose

of

making

the

data

numeric.

(Al+A2)

or

(A1)+A2

can

be

used

instead

of

+Al-FA2.

Spreadsheet

195

Brother International WP335B Owners Manual - English - Page 207

Order, Calculation, Formula

Page 207 highlights