Brother International WP1700MDS Owners Manual - English - Page 218

Recalculation

Page 218 highlights

Crr Displaying Percentages '1[Ni • : FIXED CURRENCY LX.C=CUJ NO DISPLAY m 1. Select PERCENT from the FORMAT menu to display percentages (the result will be multiplied by 100 will be followed with a percentage symbol). I 12 34 5 Icf 2. Select the number of decimal places and press iII Hiding Numeric Data FIXED CURRENCY PERCENT 1. Select NO DISPLAY from the FORMAT menu and press will appear: . This menu PLAY NO DISPLAY 2. Select NO DISPLAY to hide data (or select DISPLAY to display data that have been hidden) and press Hidden data will still be in memory but will not be displayed on the grid. For example, you might have to split complex calculations in 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 is automatically displayed 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 you must recalculate. 1. Press to display the function menu. COLUMN FORMAT C SORT CLEAR CONVERT 2. Select RECALC, and press URNJ IMPORTANT: If you are using formulas referencing to cells that are themselves referencing to other cells, it might sometimes happen that the system cannot give the correct results with a single call of the recalculation function. In such cases, call the recalculation function again until a further call does not change any result. 208

  • 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

Crr
m
Displaying
Percentages
'1[Ni
:
FIXED
CURRENCY
LX.C=CUJ
NO
DISPLAY
1.
Select
PERCENT
from
the
FORMAT
menu
to
display
percentages
(the
result
will
be
multiplied
by
100
will
be
followed
with
a
percentage
symbol).
I
1
2
3
4
5
Icf
2.
Select
the
number
of
decimal
places
and
press
iII
Hiding
Numeric
Data
FIXED
CURRENCY
PERCENT
1.
Select
NO
DISPLAY
from
the
FORMAT
menu
and
press
will
appear:
.
This
menu
PLAY
NO
DISPLAY
2.
Select
NO
DISPLAY
to
hide
data
(or
select
DISPLAY
to
display
data
that
have
been
hidden)
and
press
Hidden
data
will
still
be
in
memory
but
will
not
be
displayed
on
the
grid.
For
exam-
ple,
you
might
have
to
split
complex
calculations
in
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
is
automatically
displayed
in
the
selected
cell.
However,
if
other
cells
use
this
data
in
a
formula,
these
are
not
auto-
matically
updated.
In
order
to
have
all
results
match
the
new
data
you
must
recal-
culate.
1.
Press
to
display
the
function
menu.
COLUMN
FORMAT
C
SORT
CLEAR
CONVERT
2.
Select
RECALC,
and
press
URNJ
IMPORTANT:
If
you
are
using
formulas
referencing
to
cells
that
are
themselves
referencing
to
other
cells,
it
might
sometimes
happen
that
the
system
cannot
give
the
correct
results
with
a
single
call
of
the
recalculation
function.
In
such
cases,
call
the
recalculation
function
again
until
a
further
call
does
not
change
any
result.
208