Brother International PDP350CJ Owner's Manual - English - Page 394

Logical, functions in order to take a specified action.

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

Page 394 highlights

Logical Functions The logical functions evaluate relationships and return true" or false" results. True = 1 (or non-zero values) and false = 0. The main purpose of logical functions is the IF() function, which evaluates any of the logical functions in order to take a specified action. Function AND (logical1, logical2,...) FALSE ( ) IF (logical, true value, false value) OR (logical1, logical2,...) TRUE ( ) Description True = 1 (or non-zero), False = 0 Example Logical AND. Returns 1 if all arguments are true or 0 is any of the arguments is false. Useful with IF statements. Logical can be either logical values, arrays or references to cells or fields that contain logical values. Text is ignored. If the argument does not contain a logical value, AND returns the #TYPE# error. See also OR. You can have as many logical arguments as you want. =AND(1+3=4,3+1=3) returns 0. =AND(1+3=4,3+1=4) returns 1. =IF(AND(A1>B1,A1A2,Ascending",Descending") returns Ascending if A1 is greater than A2. Otherwise the expression returns Descending. Returns 1 if at least one of the arguments is true or 0 if all of the arguments are false. The arguments can be values, cells or field references. You can have as many logical arguments as you want. OR ignores text. If an argument does not contain a logical value, OR returns the #TYPE# error. OR is particularly useful with IF expressions. See also AND. =OR(1+2=3,2+3=5) returns 1. =OR(1+2=3,2+3=4) returns 1. =OR((1+2=2,2+3=3)returns 0. =IF(OR(A1>100,A1=B1),25,50)returns 25 if A1 is 100 or less, or A1 equals B1. Returns 1. You can use TRUE in a calculation or enter it directly into a cell or field where it is interpreted as a logical value. You must include the empty parentheses. See also FALSE. Appendix 367

  • 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
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340
  • 341
  • 342
  • 343
  • 344
  • 345
  • 346
  • 347
  • 348
  • 349
  • 350
  • 351
  • 352
  • 353
  • 354
  • 355
  • 356
  • 357
  • 358
  • 359
  • 360
  • 361
  • 362
  • 363
  • 364
  • 365
  • 366
  • 367
  • 368
  • 369
  • 370
  • 371
  • 372
  • 373
  • 374
  • 375
  • 376
  • 377
  • 378
  • 379
  • 380
  • 381
  • 382
  • 383
  • 384
  • 385
  • 386
  • 387
  • 388
  • 389
  • 390
  • 391
  • 392
  • 393
  • 394
  • 395
  • 396
  • 397
  • 398
  • 399
  • 400
  • 401
  • 402
  • 403
  • 404
  • 405
  • 406
  • 407
  • 408
  • 409
  • 410
  • 411
  • 412
  • 413
  • 414
  • 415
  • 416
  • 417
  • 418
  • 419
  • 420
  • 421
  • 422
  • 423
  • 424
  • 425
  • 426
  • 427
  • 428
  • 429
  • 430
  • 431
  • 432
  • 433
  • 434
  • 435
  • 436
  • 437
  • 438
  • 439
  • 440
Appendix
367
Logical
Functions
The logical functions evaluate relationships and return ±true" or ±false"
results. True = 1 (or non-zero values) and false = 0. The main purpose of
logical functions is the IF() function, which evaluates any of the logical
functions in order to take a specified action.
Function
Description
T
rue = 1 (or non–zero),
False = 0
Example
AND
(logical1,
logical2,...)
Logical AND.
Returns 1 if all arguments are true
or 0 is any of the arguments is false. Useful with
IF statements.
Logical
can be either logical
values, arrays or references to cells or fields that
contain logical values. Text is ignored. If the
argument does not contain a logical value, AND
returns the #TYPE# error. See also OR. You can
have as many
logical
arguments as you want.
=AND(1+3=4,3+1=3)
returns
0.
=AND(1+3=4,3+1=4)
returns
1.
=IF(AND(A1>B1,A1<C1),100,200)
returns
100 if
A1 is greater than B1 and less than C1.
Otherwise, it returns 200.
FALSE
( )
Returns 0
. You can use FALSE in a calculation
or enter it directly into a cell or field where it is
interpreted as a logical value. You must include
the empty parentheses. See also TRUE.
IF
(
logical, true
value, false value
)
Evaluates a condition, returning
onespecified
value if true and another if it is false
.
Logical
is any expression or value that can be evaluated
as true or false.
True_value
is the value returned
if the logical expression is true.
False_value
is
the value returned if the logical expression is
false.
=IF(B13=500,50,-50)
returns
50 if B13 contains
500. Otherwise, the expression
returns
-50.
=IF (D14 = ±warm",±red",±yellow")
returns
red if
D14 contains ±warm". Otherwise, the expression
returns
yellow.
=IF (A1>A2,±Ascending",±Descending")
returns
Ascending if A1 is greater than A2. Otherwise
the expression
returns
Descending.
OR
(
logical1
,
logical2
,...)
Returns 1 if at least one of the arguments is
true
or 0 if all of the arguments are false. The
arguments can be values, cells or field
references. You can have as many
logical
arguments as you want. OR ignores text. If an
argument does not contain a logical value, OR
returns the #TYPE# error. OR is particularly
useful with IF expressions. See also AND.
=OR(1+2=3,2+3=5)
returns
1.
=OR(1+2=3,2+3=4)
returns
1.
=OR((1+2=2,2+3=3)
returns
0.
=IF(OR(A1>100,A1=B1),25,50)
returns
25 if A1 is
100 or less, or A1 equals B1.
TRUE
( )
Returns 1
. You can use TRUE in a calculation
or enter it directly into a cell or field where it is
interpreted as a logical value. You must include
the empty parentheses. See also FALSE.