Brother International WP1700MDS Owners Manual - English - Page 202

2.

Functions

Using

Multiple

Arguments

@AVG

Gives

the

average

value

of

the

arguments.

The

sum

of

the

arguments

is

cal-

culated,

then

that

sum

is

divided

by

the

total

number

of

arguments.

@AVG(1

,2,3,4)

gives

(1+2+3+4)/4

-

2.5

@AVG(175)

gives

175/1

=

175

@COUNT

Gives

the

number

of

non

-blank

cells.

This

function

is

an

exception

to

the

gen-

eral

rules

in

that:

1)

the

arguments

MUST

be

cell

addresses,

and

2)

the

cell

referred

to

may

contain

alphanumeric

or

numeric

data.

@COUNT(Al

,A2,A3,A4)

gives

3

if

Al

contains

5

(numeric),

A2

contains

your

name

(alphanumeric),

A3

contains

ERROR

(this

is

not

a

blank

cell),

and

A4

is

empty.

@MAX

Gives

the

greatest

argument

(maximum).

Remember

that

a

positive

argument

is

always

greater

than

a

negative

one.

©MAX(1,234)

gives

234

@MAX(1,-99999)

gives

1

@MIN

Gives

the

smallest

argument

(minimum).

Remember

that

a

negative

argu-

ment

is

always

smaller

than

a

positive

one.

@MIN(1,234)

gives

1

@MIN(

-1,99999)

gives

-1

@SUM

Gives

the

sum

of

the

arguments.

This

function

is

very

useful

in

shortening

long

sums

when

the

arguments

belong

to

a

range.

@SUM(1,2,3,4,5)

gives

15

@SUM(A1,A2,A3,B1,B2,B3)

is

equivalent

to

@SUM(Al..B3)

@TSUM

Gives

the

total

sum

of

a

range

of

cells,

and

also

the

sum

of

each

row

and

col-

umn

of

the

range

if

they

contain

data.

This

function

is

an

exception

to

the

gen-

eral

rules

in

that:

1)

the

argument

MUST

be

a

range,

and

2)

results

are

displayed

not

only

in

the

selected

cell

(total

sum),

but

also

in

the

column

to

the

right

and

in

the

row

below

the

range.

You

must

therefore

be

sure

that

the

column

to

the

right

and

the

row

below

the

range

is

empty.

See

below

for

an

example.

709

Brother International WP1700MDS Owners Manual - English - Page 202

Suma1,a2,a3,b1,b2,b3

Page 202 highlights