Brother International WP230B Owners Manual - English - Page 205
relationship
 |
View all Brother International WP230B manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 205 highlights
As you already know, entries such as this do not always have to be numbers. They can also be formulas that direct the system to calculate the result of an operation on numbers already entered 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. 3. Enter +A2+B2 in cell C2 (the + sign is used here because a formula cannot begin with a letter). A2+B2 10 PITCH:10 4. Enter +A2-B2 in cell D2. +A2B2 3 10 2 12 5. Enter +A2*B2 in cell E2. 3 10 2 12 PITCH:1B PTTC11:10 Spreadsheet 193
-
1 -
2
-
3
-
4
-
5
-
6
-
7
-
8
-
9
-
10
-
11
-
12
-
13
-
14
-
15
-
16
-
17
-
18
-
19
-
20
-
21
-
22
-
23
-
24
-
25
-
26
-
27
-
28
-
29
-
30
-
31
-
32
-
33
-
34
-
35
-
36
-
37
-
38
-
39
-
40
-
41
-
42
-
43
-
44
-
45
-
46
-
47
-
48
-
49
-
50
-
51
-
52
-
53
-
54
-
55
-
56
-
57
-
58
-
59
-
60
-
61
-
62
-
63
-
64
-
65
-
66
-
67
-
68
-
69
-
70
-
71
-
72
-
73
-
74
-
75
-
76
-
77
-
78
-
79
-
80
-
81
-
82
-
83
-
84
-
85
-
86
-
87
-
88
-
89
-
90
-
91
-
92
-
93
-
94
-
95
-
96
-
97
-
98
-
99
-
100
-
101
-
102
-
103
-
104
-
105
-
106
-
107
-
108
-
109
-
110
-
111
-
112
-
113
-
114
-
115
-
116
-
117
-
118
-
119
-
120
-
121
-
122
-
123
-
124
-
125
-
126
-
127
-
128
-
129
-
130
-
131
-
132
-
133
-
134
-
135
-
136
-
137
-
138
-
139
-
140
-
141
-
142
-
143
-
144
-
145
-
146
-
147
-
148
-
149
-
150
-
151
-
152
-
153
-
154
-
155
-
156
-
157
-
158
-
159
-
160
-
161
-
162
-
163
-
164
-
165
-
166
-
167
-
168
-
169
-
170
-
171
-
172
-
173
-
174
-
175
-
176
-
177
-
178
-
179
-
180
-
181
-
182
-
183
-
184
-
185
-
186
-
187
-
188
-
189
-
190
-
191
-
192
-
193
-
194
-
195
-
196
-
197
-
198
-
199
-
200 -
201 -
202 -
203 -
204 -
205 -
206 -
207 -
208 -
209 -
210 -
211
-
212
-
213
-
214
-
215
-
216
-
217
-
218
-
219
-
220
-
221
-
222
-
223
-
224
-
225
-
226
-
227
-
228
-
229
-
230
-
231
-
232
-
233
-
234
-
235
-
236
-
237
-
238
-
239
-
240
-
241
-
242
-
243
-
244
-
245
-
246
-
247
-
248
-
249
-
250
-
251
-
252
-
253
-
254
-
255
-
256
-
257
-
258
-
259
-
260
-
261
-
262
-
263
-
264
-
265
-
266
-
267
-
268
-
269
-
270
-
271
-
272
-
273
-
274
-
275
-
276
-
277
-
278
-
279
-
280
-
281
-
282
-
283
-
284
-
285
-
286
-
287
-
288
-
289
-
290
-
291
-
292
-
293
-
294
-
295
-
296
-
297
-
298
-
299
-
300
-
301
-
302
-
303
-
304
-
305
-
306
-
307
-
308
-
309
-
310
-
311
-
312
-
313
-
314
-
315
-
316
-
317
-
318
-
319
-
320
-
321
-
322
-
323
-
324
-
325
-
326
-
327
-
328
-
329
-
330
-
331
-
332
-
333
-
334
-
335
-
336
-
337
-
338
-
339
-
340
 |
 |
As
you
already
know,
entries
such
as
this
do
not
always
have
to
be
numbers.
They
can
also
be
formulas
that
direct
the
system
to
calculate
the
result
of
an
operation
on
numbers
already
entered
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.
...
....................
3.
Enter
+A2+B2
in
cell
C2
(the
+
sign
is
used
here
because
a
formula
cannot
begin
with
a
letter).
A2+B2
10
PITCH:10
..
..
....
•
4.
Enter
+A2
—B2
in
cell
D2.
+A2
B2
3
10
2
12
PITCH:1B
5.
Enter
+A2*B2
in
cell
E2.
PTTC11:10
3
10
2
12
• • • •
Spreadsheet
193