Brother WP330MDS - Manual (Page 209)

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 @ lF(condition, argumenti, argument2), and can be
read in plain English as: if the “condition” is satisfied, then display
“argumentr. If the condition is not satisfied, then display “argument2”. The
“condition” 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
@1F(A1 >100,100,50) gives 100 if A1 is greater than 100, and 50 if A1 is
equal to 100 or smaller than 100
@ IF(A1 >100,100,A1) gives 100 if A1 =200 and 60 if A1 =60
• “Argument2” can be omitted. In that case, the function returns
“argumenti” 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 “argumenti” and “argument2” are both omitted, the function returns 1
when the condition is satisfied, and zero when the condition is not
satisfied.
@IF(A1=50) is equivalent to @1F(A1=50,1,0); 100*@IF(A1=50) is
equivalent to @IF(A1 =50,100)
• The “condition” can be a cell address. In that case, “argumenti” 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 A1=50 and gives 0 if A1 contains a label.
The following example shows how to use the @TSUM function.
1. Enter the numbers shown below in the range A1 ..C3, then enter @TSUM{A1 ..C3)
in D4.
@TSUM{Al..C3)i
A B C D
PITCH: 10
G
1 1 2 3
2 4 5 6
3
4
7 8 9
2. Press RETURN. The results appear as follows:
@TSUM(A1..C3>| PITCH: 10
A ■■■i.-BV/.-.v.-.v;-.- c ■ b . ■ -
V
.1. 1 2 3 6
4 5 6 15
3 7 s Q 34
4 12 15 18 i? issss;;»
199