Brother International WP1700MDS Owners Manual - English - Page 194

0

cr)

I

m

Formulas

A

formula

is

made

of

operators,

operands,

and

possibly

pairs

of

parentheses

to

change

the

order

of

calculation.

Operators

The

operators

that

are

recognized

by

the

word

processor

are,

in

order

of

prece-

dence:

Symbol

Operator

+

-

Positive

and

negative

sign

#

Exponentiation

*

/

Multiplication,

division

+

-

Addition,

subtraction

•

The

+

and

-

operators

are

considered

as

the

sign

of

the

following

operand

when

they

come

first

in

a

formula,

immediately

after

a

left

parenthesis

or

another

operator.

•

The

#

operator

performs

only

integer

exponentiation.

If

the

exponent

(the

next

operand

after

#)

has

a

decimal

value,

it

will

be

rounded

to

the

closest

integer

before

exponentiation

is

performed.

Therefore,

this

operator

cannot

be

used

to

calculate

roots

(although

roots

can

always

be

written

as

a

decimal

exponent

in

math).

Zero

with

any

positive

exponent

gives

zero.

Zero

with

a

negative

exponent

gives

"Invalid

entry."

•

Division

by

zero

is

invalid.

•

A

sequence

of

three

or

more

operators

makes

a

formula

invalid

(2+*

-1

is

invalid).

•

A

sequence

of

two

operators

is

valid

only

if

the

second

operator

is

a

sign

+

or

-

(5

*-2

is

valid

and

gives

-10

while

1-

*2

is

invalid).

Operands

An

operand

can

be

a

valid

number,

the

address

of

a

cell

containing

numeric

data,

a

function,

or

a

valid

formula

included

in

a

pair

of

parentheses.

Examples

of

valid

operands

123

direct

number

Al

or

al

cell

address;

Al

must

contain

numeric

data

©SUM(A1..B6)

valid

function

(Al

+5*

@

SUM(B1..B12))

valid

formula

included

in

a

pair

of

parentheses

184

Brother International WP1700MDS Owners Manual - English - Page 194

Formulas

Page 194 highlights