Brother International WP230B Owners Manual - English - Page 228

Recalculation

Page 228 highlights

Displaying Percentages MENU FIXED CURRENCY :PEREMIT: NO DI.SPLAY 1. Select PERCENT from the FORMAT menu to display percentages (the result is be multiplied by 100 and followed with a percent sign). 1'S.' 4t00 0 1 2 3 4 5 i'l50161::VOrtilf17,01.:ditftWEVY* 2. Select the number of decimal places and press RETURN. Hiding Numeric Data MlfII!'!114: FIXED CURRENCY PERCENT ::NO,DIASPI*., rr r r r r 1. Select NO DISPLAY from the FORMAT menu and press RETURN. This menu appears: pi ..... NO DISPLAY 2. Select NO DISPLAY to hide data (or select DISPLAY to display data that have been hidden) and press RETURN. Hidden data still in memory but is not displayed on the grid. For example, you might have to split complex calculations into more simple steps. In that case, you do not need to display or print intermediate results. Recalculation When you input or edit numeric data, the result appears in the selected cell. However, if other cells use this data in a formula, these are not automatically updated. In order to have all results match the new data cells, you must recalculate. 1. Press MENU to display the function menu. malrt COLUMN FORMAT iiEtALCSORT CLEAR CONVERT 2. Select RECALC and press RETURN. NOTE: If you are using formulas that reference cells that are themselves a reference to other cells, it might sometimes happen that the system cannot give the correct results with one recalculation. In such cases, recalculate again until you do not see any results change. 216 Spreadsheet

  • 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

Displaying
Percentages
MENU
FIXED
CURRENCY
:PEREMIT:
NO
DI.SPLAY
1.
Select
PERCENT
from
the
FORMAT
menu
to
display
percentages
(the
result
is
be
multiplied
by
100
and
followed
with
a
percent
sign).
'
1.'
S4t00
0
1
2
3
4
5
i'l50161::VOrtilf17
,
01.
:ditftWEVY*
2.
Select
the
number
of
decimal
places
and
press
RETURN.
Hiding
Numeric
Data
MlfII!'!114:
FIXED
CURRENCY
PERCENT
::NO,DIASPI*.,
r
r
r
r
r
r
1.
Select
NO
DISPLAY
from
the
FORMAT
menu
and
press
RETURN.
This
menu
appears:
pi
..
...
NO
DISPLAY
2.
Select
NO
DISPLAY
to
hide
data
(or
select
DISPLAY
to
display
data
that
have
been
hidden)
and
press
RETURN.
Hidden
data
still
in
memory
but
is
not
displayed
on
the
grid.
For
example,
you
might
have
to
split
complex
calculations
into
more
simple
steps.
In
that
case,
you
do
not
need
to
display
or
print
intermediate
results.
Recalculation
When
you
input
or
edit
numeric
data,
the
result
appears
in
the
selected
cell.
However,
if
other
cells
use
this
data
in
a
formula,
these
are
not
automatically
updated.
In
order
to
have
all
results
match
the
new
data
cells,
you
must
recalculate.
1.
Press
MENU
to
display
the
function
menu.
malrt
COLUMN
FORMAT
iiEtALCSORT
CLEAR
CONVERT
2.
Select
RECALC
and
press
RETURN.
NOTE:
If
you
are
using
formulas
that
reference
cells
that
are
themselves
a
reference
to
other
cells,
it
might
sometimes
happen
that
the
system
cannot
give
the
correct
results
with
one
recalculation.
In
such
cases,
recalculate
again
until
you
do
not
see
any
results
change.
216
Spreadsheet