Brother International WP7550JPLUS Owner's Manual - English - Page 102

Performing, Calculations

Get Brother International WP7550JPLUS PDF manuals and user guides View all Brother International WP7550JPLUS manuals
Add to My Manuals
Save this manual to your list of manuals

Page 102 highlights

Performing Calculations Numeric data are direct numbers or formulas and are calculated. When data is recognized as numeric, Spreadsheet will check whether or not the data is valid. • If the data is valid, the result (a number) is calculated. If the number can fit in the cell, it is automatically right-aligned. If the number cannot fit in the cell, a string of asterisks will fill the cell. The correct number is, however, kept in the memory, and will be displayed if you adjust the width of the column. • If the data is not valid, ERROR will be displayed in the cell, and one of the following messages will appear: When a denominator is zero. Division by zero! Press any key to continue. When a result is positive and contains more than 10 digits. 4 Numeric overflow! I Press any key to continue. When a result is negative and contains more than 10 digits. 4 Numprio undprflowl 1 Press any key to continue. * If a number contains characters other than numeric ones and a decimal point (e.g. 1,000, 100$, 1A2). I Invalid entry! Press any key to continue. Direct Numbers A direct number is made of digits and possibly a decimal point. Other characters will make the data invalid for calculation. The maximum number of digits is 10 to the left of the decimal point and 5 to the right (zeroes preceding other digits are not counted). Here are some examples of valid and invalid numbers: Valid 1234 0.94956 00001 000000000000001 (zeroes are ignored) Invalid 1,000 (comma is invalid) 125$ ($ is invalid) 12a12 (a is invalid) 99999999999 (more than 10 digits) Spreadsheet 94

  • 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
Performing
Calculations
Numeric
data
are
direct
numbers
or
formulas
and
are
calculated.
When
data
is
recognized
as
numeric,
Spreadsheet
will
check
whether
or
not
the
data
is
valid.
•
If
the
data
is
valid,
the
result
(a
number)
is
calculated.
If
the
number
can
fit
in
the
cell,
it
is
automatically
right
-aligned.
If
the
number
cannot
fit
in
the
cell,
a
string
of
asterisks
will
fill
the
cell.
The
correct
number
is,
however,
kept
in
the
memory,
and
will
be
displayed
if
you
adjust
the
width
of
the
column.
•
If
the
data
is
not
valid,
ERROR
will
be
displayed
in
the
cell,
and
one
of
the
following
messages
will
appear:
When
a
denominator
is
zero.
Division
by
zero!
Press
any
key
to
continue.
When
a
result
is
positive
and
contains
more
than
10
digits.
I
4
Numeric
overflow!
Press
any
key
to
continue.
When
a
result
is
negative
and
contains
more
than
10
digits.
1
4
Numprio
undprflowl
Press
any
key
to
continue.
*
If
a
number
contains
characters
other
than
numeric
ones
and
a
decimal
point
(e.g.
1,000,
100$,
1A2).
I
Invalid
entry!
Press
any
key
to
continue.
Direct
Numbers
A
direct
number
is
made
of
digits
and
possibly
a
decimal
point.
Other
characters
will
make
the
data
invalid
for
calculation.
The
maximum
number
of
digits
is
10
to
the
left
of
the
decimal
point
and
5
to
the
right
(zeroes
preceding
other
digits
are
not
counted).
Here
are
some
examples
of
valid
and
invalid
numbers:
Valid
Invalid
1234
0.94956
1,000
(comma
is
invalid)
125$
($
is
invalid)
00001
12a12
(a
is
invalid)
000000000000001
99999999999
(zeroes
are
ignored)
(more
than
10
digits)
Spreadsheet
94