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

spreadsheet

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

@REPEAT Repeats the argument the number of times specified. Two data entries are required between the parentheses: the argument itself, which must be a string of characters between a pair of double quote marks or the address of a cell containing alphanumeric data, and a direct number that specifies the number of repetitions. If that number is not an integer, it is first rounded off to the closest integer. @REPEAT("Aa",2) gives AaAa @REPEAT("2",3) gives 222 (alphanumeric) @REPEAT(A1,2) gives AaAa (ifAl contains Aa) @ROUND : Rounds off the argument to the number of specified decimal places. Two data entries are required between the parentheses: the argument itself, and a direct number that specifies the number of decimal places. If that number is not an integer, it is first rounded off to the closest integer. eROUND(1.66666,2) gives 1.67 @ROUND(1.66666,3) gives 1.667 @ROUND(1.66666,2.1) gives 1.67 @ROUND(1.66666,2.5) gives 1.667 @SQUARE : Gives the square of the argument. The argument multiplied by itself is returned: the result is always a positive number. @SQUARE(5) gives 25 @SQUARE(0) gives 0 @SQUARE(-5) gives 25 @SQRT : Gives the square root of the argument. The result multiplied by itself is equal to the argument. The argument may not be negative. @SQRT(25) gives 5 @SQRT(2) gives 1.41421 @SQRT(-25) is invalid Functions using multiple arguments @AVG : Gives the average value of the arguments. The sum of the arguments is calculated, then that sum is divided by the total number of arguments. @AVG(1,2,3,4) gives (1+2+3+4)/4 = 2.5 @AVG(175) gives 175/1 = 175 @COUNT : Gives the number of non-blank cells. This function is an exception to the general rules in that the cell referred to may contain either alphanumeric or numeric data. @COUNT(A1,A2,A3,A4) gives 3 if Al contains 5 (numeric), A2 contains your name (alphanumeric), A3 contains ERROR (this is not a blank cell), and A4 is empty. spreadsheet 100

  • 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
@REPEAT
Repeats
the
argument
the
number
of
times
specified.
Two
data
entries
are
required
between
the
parentheses:
the
argument
itself,
which
must
be
a
string
of
characters
between
a
pair
of
double
quote
marks
or
the
address
of
a
cell
containing
alphanumeric
data,
and
a
direct
number
that
specifies
the
number
of
repetitions.
If
that
number
is
not
an
integer,
it
is
first
rounded
off
to
the
closest
integer.
@REPEAT("Aa",2)
gives
AaAa
@REPEAT("2",3)
gives
222
(alphanumeric)
@REPEAT(A1,2)
gives
AaAa
(if
Al
contains
Aa)
@ROUND
:
Rounds
off
the
argument
to
the
number
of
specified
decimal
places.
Two
data
entries
are
required
between
the
parentheses:
the
argument
itself,
and
a
direct
number
that
specifies
the
number
of
decimal
places.
If
that
number
is
not
an
integer,
it
is
first
rounded
off
to
the
closest
integer.
eROUND(1.66666,2)
gives
1.67
@ROUND(1.66666,3)
gives
1.667
@ROUND(1.66666,2.1)
gives
1.67
@ROUND(1.66666,2.5)
gives
1.667
@SQUARE
:
Gives
the
square
of
the
argument.
The
argument
multiplied
by
itself
is
returned:
the
result
is
always
a
positive
number.
@SQUARE(5)
gives
25
@SQUARE(
-5)
gives
25
@SQUARE(0)
gives
0
@SQRT
:
Gives
the
square
root
of
the
argument.
The
result
multiplied
by
itself
is
equal
to
the
argument.
The
argument
may
not
be
negative.
@SQRT(25)
gives
5
@SQRT(-25)
is
invalid
Functions
using
multiple
arguments
@SQRT(2)
gives
1.41421
@AVG
:
Gives
the
average
value
of
the
arguments.
The
sum
of
the
arguments
is
calculated,
then
that
sum
is
divided
by
the
total
number
of
arguments.
@AVG(1,2,3,4)
gives
(1+2+3+4)/4
=
2.5
@AVG(175)
gives
175/1
=
175
@COUNT
:
Gives
the
number
of
non
-blank
cells.
This
function
is
an
exception
to
the
general
rules
in
that
the
cell
referred
to
may
contain
either
alphanumeric
or
numeric
data.
@COUNT(A1,A2,A3,A4)
gives
3
if
Al
contains
5
(numeric),
A2
contains
your
name
(alphanumeric),
A3
contains
ERROR
(this
is
not
a
blank
cell),
and
A4
is
empty.
spreadsheet
100