Brother International WP1700MDS Owners Manual - English - Page 199

What

is

a

Range

of

Cells?

A

range

is

no

more

than

a

group

of

cell

enclosed

in

a

rectangle,

and

therefore,

can

be

specified

by

the

addresses

of

two

opposite

corners.

When

using

math

functions,

you

specify

a

range

using

the

notation

Al

..C3,

for

example.

You

could

also

specify

the

same

range

with

A3..C1,

Cl

..A3,

or

C3..A1.

Range

A1..C3,

A3..C1,

C1..A3,

or

C3..A1

QETCH•

1

0

This

is

not

a

range

Easy

Input

of

a

Range

Rather

than

typing

in

the

cell

address

at

each

corner

of

the

range,

you

are

able

to

mark

and

highlight

the

range

to

be

used.

The

spreadsheet

will

automatically

define

the

top

left

and

bottom

right

corners

of

the

range.

Suppose

you

want

to

calculate

the

sum

of

the

range

Al

..E2

and

display

the

result

in

Gl.

NTCH710

I

a

10

1.

Move

the

cursor

to

G1

and

type

@SUM(.

As

soon

as

you

type

the

left

paren-

thesis

of

the

function,

the

following

message

appears:

Cuter

cell

specification.

2.

Instead

of

typing

Al

,

move

the

cursor

to

Al

and

press

fiNg)

+

In

(see

"Help

Menus"

on

page

176).

@SUM(Al..

is

now

displayed

in

the

input

area.

2

a

10

PITEH,10

3.

Move

the

cursor

to

the

opposite

corner

of

the

range

(E2).

w

.

I

w

CC

Brother International WP1700MDS Owners Manual - English - Page 199

Input, Range

Page 199 highlights