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

Order, Calculation, Formula

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 104 highlights

Please remember the following rules about operands: • A cell address can be written using either upper or lower case fetters. 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 of Al+A2, enter +Al +A2, (AI +A2), or (A1)+A2. • If a cell that is referred to while doing a calculation contains alphanumeric data, the formula is invalid, and ERROR will be displayed. An empty cell, however, is valid and assumed to contain zero. Order of Calculation of a Formula The calculation of a formula is performed in the order of precedence of the operators: 1. The 4- or - sign is applied to the operand directly to the sign's right. 2. Exponential calculations are performed. 3. Multiplication and division calculations are performed. 4. Addition and subtraction calculations are performed. Example: 2#3*4-2 8*4-2 32-2 30 When two or more operators have the same order of precedence (multiplication and divisions, or addition and subtraction), calculation is carried out from left to right. Example: 1+3+4-2 2#3#2 4+4-2 8#2 8-2 64 6 To modify the order of calculation, you may use pairs of parentheses. The formula in parentheses is calculated first. Example: 1+3*4 (1+3)*4 1+12 4*4 13 16 Parentheses can contain other pairs of parentheses. Calculation proceeds from the innermost pair of parentheses. Example: ((3*4+1)*4+3)*4-12 (13*4+3)*4-12 55*4-12 220-12 208 One pair of parentheses can contain up to 5 other pairs. Using more than 5 pairs of parentheses in one pair of parentheses makes the formula invalid. The formula will also be invalid it parentheses do not come in pairs. Parentheses can be used for the simple purpose of making the data numeric. (A1+A2) or (A1)+A2 can be used instead of +Al +A2. Spreadsheet 96

  • 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
Please
remember
the
following
rules
about
operands:
•
A
cell
address
can
be
written
using
either
upper
or
lower
case
fetters.
When
a
cell
address
has
to
come
fi
rst
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
of
Al+A2,
enter
+Al
+A2,
(AI
+A2),
or
(A1)+A2.
•
If
a
cell
that
is
referred
to
while
doing
a
calculation
contains
alphanumeric
data,
the
formula
is
invalid,
and
ERROR
will
be
displayed.
An
empty
cell,
however,
is
valid
and
assumed
to
contain
zero.
Order
of
Calculation
of
a
Formula
The
calculation
of
a
formula
is
performed
in
the
order
of
precedence
of
the
operators:
1.
The
4-
or
-
sign
is
applied
to
the
operand
directly
to
the
sign's
right.
2.
Exponential
calculations
are
performed.
3.
Multiplication
and
division
calculations
are
performed.
4.
Addition
and
subtraction
calculations
are
performed.
Example:
2#3*4-2
8*4-2
32-2
30
When
two
or
more
operators
have
the
same
order
of
precedence
(multiplication
and
divisions,
or
addition
and
subtraction),
calculation
is
carried
out
from
left
to
right.
Example:
1+3+4-2
2#3#2
4+4-2
8#2
8-2
64
6
To
modify
the
order
of
calculation,
you
may
use
pairs
of
parentheses.
The
formula
in
parentheses
is
calculated
first.
Example:
1+3*4
(1+3)*4
1+12
4*4
13
16
Parentheses
can
contain
other
pairs
of
parentheses.
Calculation
proceeds
from
the
innermost
pair
of
parentheses.
Example:
((3*4+1)*4+3)*4-12
(13*4+3)*4-12
55*4-12
220-12
208
One
pair
of
parentheses
can
contain
up
to
5
other
pairs.
Using
more
than
5
pairs
of
parentheses
in
one
pair
of
parentheses
makes
the
formula
invalid.
The
formula
will
also
be
invalid
it
parentheses
do
not
come
in
pairs.
Parentheses
can
be
used
for
the
simple
purpose
of
making
the
data
numeric.
(A1
+A2)
or
(A1)+A2
can
be
used
instead
of
+Al
+A2.
Spreadsheet
96