Brother International WP230B Owners Manual - English - Page 210

@SUM(4.

xox

1

2

3

4

5

6

7

8

4.

Press

RETURN.

The

cursor

is

back

on

G1

and

the

result

is

calculated.

.9)

sumAl

1

2

3

4

5

6

7

8

9

10

MITA

5.

Press

RETURN

again.

The

result,

55,

appears

in

cell

G1.

PITCII:

10

1

6

7

8

9

10

List

of

Functions

Some

functions

can

process

only

one

argument.

Arguments

may

include

not

only

direct

number

inputs

but

cell

addresses

as

well.

The

most

sophisticated

function

of

spreadsheet

is

that

it

can

process

multiple

arguments.

Arguments

may

be

written

individually,

separated

by

commas;

or

if

all

the

arguments

belong

to

a

range,

the

range

can

be

specified

by

the

addresses

of

two

opposite

corners

with

two

periods

between

as

a

separator.

You

can

define

arguments

as

a

range

or

any

combination

of

direct

numbers

and

cell

addresses.

1.

Functions

Using

a

Single

Argument

@ABS

Gives

the

absolute

value

of

the

argument.

If

the

argument

is

positive,

or

zero,

the

same

value

is

returned;

if

the

argument

is

negative,

the

opposite

of

the

argument

is

returned.

@ABS(5)

gives

5

OABS(-5)

gives

5

198

Spreadsheet

Brother International WP230B Owners Manual - English - Page 210

individually

Page 210 highlights