Brother International WP1700MDS Owners Manual - English - Page 203

2.

Functions

Using

Multiple

Arguments

@IF

This

special

function

checks

whether

or

not

a

specified

condition

is

verified,

and

displays

a

value

that

depends

on

the

result

of

that

check.

The

general

form

of

this

function

is

@

IF

(condition,

argumentl

,

argument2),

and

can

be

read

in

plain

English

as:

if

the

"condition"

is

satisfied,

then

display

"argu-

mentl".

If

the

condition

is

not

satisfied,

then

display

"argument2".

The

"condi-

tion"

is

usually

an

arithmetic

comparison,

using

two

values

(number

or

cell

address)

and

one

of

the

following

comparison

operators:

equal

to

<=

less

than

or

equal

to

<

less

than

>=

greater

than

or

equal

to

greater

than

<>

not

equal

to

@IF(A1>100,100,50)

gives

100

if

Al

is

greater

than

100,

and

50

if

Al

is

equal

to

100

or

smaller

than

100

@IF(Al

>100,100,A1)

gives

100

if

A1=200

and

60

if

A1

,

-60

•

"Argument2"

can

be

omitted.

In

that

case,

the

function

returns

"argu-

mentl"

when

the

condition

is

satisfied,

and

zero

when

the

condition

is

not

satisfied.

IF(A1=50,100)

is

equivalent

to

@IF(A1=50,100,0)

•

If

"argumentl"

and

"argument2"

are

both

omitted,

the

function

returns

1

when

the

condition

is

satisfied,

and

zero

when

the

condition

is

not

satis-

fied.

@

I

F(Al

=50)

is

equivalent

to

@

I

F(Al

=50,1,0);

100

*

@

I

F(Al

=5(3)

is

equivalent

to

@

IF(Al

=50,100)

•

The

"condition"

can

be

a

cell

address.

In

that

case,

"argumentl"

and

"argument2"

must

be

omitted.

The

function

returns

1

if

the

cell

contains

a

numeric

data,

and

zero

if

the

cell

contains

alphanumeric

data.

@IF(A1)

gives

1

if

Al

=50

and

gives

0

if

Al

contains

a

label.

The

following

example

shows

how

to

use

the

@TSUM

function.

111

JJJ

U)

ui

0_

1.

Enter

the

numbers

shown

below

in

the

range

Al

..C3,

then

enter

@TSUM(Al..C3)

in

D4.

',

P1

-

cP1M(

Al

. .

C3'

PTTCP,

n

4

7

8

2.

The

results

appear

as

follows:

Press

r

.

PITCH:10

1

L

s

b

4

5

6

15

7

8

9

24

12

15

lE

v,

A_

Brother International WP1700MDS Owners Manual - English - Page 203

Pitch:10

Page 203 highlights