Notes, Using simple formulas, Mm a – Brother WP330MDS User Manual
Page 201: Enter, Position the cursor on, Type, And press
Attention! The text in this document has been recognized automatically. To view the original document, you can use the "Original mode".
NOTES:
• A cell address can be written using either small or capital letters.
• When a cell address has to come first in a formula, it must be preceded with a +
or - sign, or by a left parenthesis. Otherwise, the formula will be considered
alphanumeric data and will not be calculated. Therefore, instead ofA1+A2, enter
+A UA2, (A 1+A2), or (A 1)+A2.
• If a cell referred to contains alphanumeric data, the formula is invalid, and
ERROR will be displayed. An empty cell, however, is valid and assumed to con
tain zero.
Using Simple Formulas
In order to familiarize yourself with the formulas, try the following examples.
1
.
Enter
1+2
in cell
Al
. (Position the cursor on
A1
, type
1+2,
and press
RETURN.)
Al
;(1+2)
PITCH: 10
1
&
mm
A
a
©
■
C
D
■
.
. . f
■ ■
The calculation is made automatically, and the result displayed in A1. The formula as
you typed it, however, will remain, and appear in the input area whenever the cursor is
placed on cell Al.
As you already know, inputs such as this do not always have to be numbers. They
may also be formulas that direct the system to calculate the result of an operation on
numbers already input into the spreadsheet, using cell addresses rather than direct
numbers. This function allows you to create a mathematical relationship between
desired cells that remains unchanged, regardless of the content of those cells.
2. Enter 10 in cell A2, then enter 2 in cell B2.
2
'mA:.
B '.cv
PITCH: 10
1
3
lU
'Z
s
3. Enter +A2+B2 in cell C2 (the + sign is used here because a formula cannot begin
with a letter).
+A2+B2
A
PITCH: 10
■i-i;
3
■2;:
10
2
191