Brother International WP230B Owners Manual - English - Page 204

•

A

sequence

of

two

operators

is

valid

only

if

the

second

operator

is

a

+

or

—

sign

(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

OSUM(Al..B6)

valid

function

(A1+5*OSUM(B1..B12))

valid

formula

included

in

a

pair

of

parentheses

NOTES:

•

You

can

type

a

cell

address

using

either

small

or

capital

letters.

•

When

a

cell

address

has

to

come

first

in

a

formula,

it

must

be

preceded

with

a

.4-

or

—

sign,

or

by

a

left

parenthesis.

Otherwise,

the

formula

is

considered

alphanumeric

data

and

is

not

calculated.

Therefore,

instead

of

Al+A2,

enter

+Al+A2,

(A1+A2),

or

(A1)4

-A2.

•

If

a

cell

referred

to

contains

alphanumeric

data,

the

formula

is

invalid

and

ERROR

is

displayed.

An

empty

cell,

however,

is

valid

and

assumed

to

contain

zero.

Using

Simple

Formulas

In

order

to

familiarize

yourself

with

the

formulas,

try

the

following

examples.

1.

Enter

1+2

in

cell

Al.

(Place

the

cursor

in

Al,

type

1+2,

and

press

RETURN.)

The

calculation

is

made

automatically

and

the

result

displayed

in

Al.

The

formula

as

you

typed

it,

however,

remains

and

appears

in

the

input

area

whenever

the

cursor

is

placed

in

cell

Al.

192

Spreadsheet

Brother International WP230B Owners Manual - English - Page 204

Operands, Using, Simple, Formulas

Page 204 highlights