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

Symbol, Operator

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

Formulas A formula is made of operators, operands, and possibly pairs of parentheses to control the order of calculation. Operators: The operators that are recognized by the system are, in order of precedence: Symbol - *1 Operator Positive and negative sign Exponentiation Multiplication, division Addition, subtraction The following rules apply to using operators in formulas: • The + and - operators are considered as the positive or negative sign of the following operand when they come first in a formula, immediately after a left parenthesis or another operator. • The # operator performs only integer exponentiation. If the exponent (the next operand after #) has a decimal value, it will be rounded to the closest integer before exponentiation is performed. Therefore, this operator cannot be used to calculate roots (although roots can always be written as a decimal exponent in math). Zero with any positive exponent gives zero. Zero with a negative exponent gives "Invalid entry! Press any key to continue." • Division by zero is invalid. • A sequence of three or more operators makes a formula invalid (2+*-1 is invalid). • A sequence of two operators is valid only if the second operator is a + or - sign. Example: 5*-2 is valid and gives -10 1-*2 is invalid. Operands: An operand can be a valid number, the address of a cell containing numeric data, a function, or a valid formula included in a pair of parentheses. Here are some examples of valid operands: Valid Operand 123 Al or al OSUM(Al B6) (Al +5*@SUM(B1.312)) Operand Description valid direct number cell address valid function valid formula included in a pair of parentheses Spreadsheet 95

  • 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
Formulas
A
formula
is
made
of
operators,
operands,
and
possibly
pairs
of
parentheses
to
control
the
order
of
calculation.
Operators:
The
operators
that
are
recognized
by
the
system
are,
in
order
of
precedence:
Symbol
Operator
-
*1
Positive
and
negative
sign
Exponentiation
Multiplication,
division
Addition,
subtraction
The
following
rules
apply
to
using
operators
in
formulas:
•
The
+
and
-
operators
are
considered
as
the
positive
or
negative
sign
of
the
following
operand
when
they
come
first
in
a
formula,
immediately
after
a
left
parenthesis
or
another
operator.
•
The
#
operator
performs
only
integer
exponentiation.
If
the
exponent
(the
next
operand
after
#)
has
a
decimal
value,
it
will
be
rounded
to
the
closest
integer
before
exponentiation
is
performed.
Therefore,
this
operator
cannot
be
used
to
calculate
roots
(although
roots
can
always
be
written
as
a decimal
exponent
in
math).
Zero
with
any
positive
exponent
gives
zero.
Zero
with
a
negative
exponent
gives
"Invalid
entry!
Press
any
key
to
continue."
•
Division
by
zero
is
invalid.
•
A
sequence
of
three
or
more
operators
makes
a
formula
invalid
(2+*
-1
is
invalid).
•
A
sequence
of
two
operators
is
valid
only
if
the
second
operator
is
a
+
or
-
sign.
Example:
5*
-2
is
valid
and
gives
-10
1
-*2
is
invalid.
Operands:
An
operand
can
be
a
valid
number,
the
address
of
a
cell
containing
numeric
data,
a
function,
or
a
valid
formula
included
in
a
pair
of
parentheses.
Here
are
some
examples
of
valid
operands:
Valid
Operand
Operand
Description
123
valid
direct
number
Al
or
al
cell
address
OSUM(Al
B6)
valid
function
(Al
+5*@SUM(B1.312))
valid
formula
included
in
a
pair
of
parentheses
Spreadsheet
95