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
True = 1 (or non–zero),
False = 0
Example
AND
(logical1,
logical2,...)
LogicalAND.
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.
Содержание Ensemble PDP-100J
Страница 11: ......
Страница 71: ...Getting Started 60 Optional Accessories Fax Modem Data Modem Scanner Cut Sheet Feeder ...
Страница 72: ......
Страница 83: ......
Страница 84: ...Word Processing 71 3 Word Processing Important Word Processing Tips ENTER ENTER TAB SPACEBAR TAB ...
Страница 152: ......
Страница 217: ...Spreadsheet 203 The following dialog box appears ...
Страница 219: ......
Страница 262: ......
Страница 269: ......
Страница 284: ......
Страница 301: ......
Страница 306: ...Calculator 287 Cut and paste Handling Error or Overflow Conditions To clear an error ...
Страница 308: ...Calculator 289 Converting Measurements S S S S S S To convert ...
Страница 312: ......
Страница 325: ......
Страница 327: ...Book Reader 306 To close a book Using Information and Text To read a book ...
Страница 329: ...Book Reader 308 Printing from Book Reader To print selected text from a book To print the current page ...
Страница 330: ......
Страница 333: ......
Страница 337: ...Text File Editor 314 ...
Страница 338: ......
Страница 345: ......
Страница 349: ...Scanner 324 What to do if an error occurs Error Condition Message Solution ...
Страница 350: ......
Страница 379: ......
Страница 387: ...Appendix 360 Color Clip Art SNOWMAN TEA TIGER TURTLECA WANDFLOW WATERLIL ...
Страница 396: ...Appendix 369 Print Functions Function Description Example ...
Страница 405: ...Appendix 378 Fonts Occidental Font Symbols keyboard International keyboard Math Symbols ...
Страница 406: ...Appendix 379 Ping Pong Font Pointer keyboard Numbers keyboard Symbols keyboard Other Symbols ...
Страница 407: ...Appendix 380 Shattuck Avenue Font Symbols keyboard International keyboard Math Symbols ...
Страница 408: ...Appendix 381 URW Mono Font Symbols keyboard International keyboard Math Symbols ...
Страница 409: ...Appendix 382 URW Roman Font Symbols keyboard International keyboard Math Symbols ...
Страница 410: ...Appendix 383 URW Sans Font Symbols keyboard International keyboard Math Symbols ...
Страница 411: ...Appendix 384 URW SymbolsPS Font Bracket keyboard Greek keyboard Symbol Math keyboard Symbol Other keyboard ...
Страница 414: ......
Страница 418: ...Glossary 390 ...
Страница 420: ...Glossary 392 0 1 1 1 ...
Страница 421: ...Glossary 393 text style sheet ...
Страница 422: ...Glossary 394 ...
Страница 423: ......
Страница 428: ...Index 399 D cont d 1 0 1 1 1 1 0 1 0 1 1 0 2 1 0 0 0 1 0 ...
Страница 430: ...Index 401 F cont d 1 1 0 0 1 0 0 0 0 0 0 0 0 0 G 1 0 1 ...
Страница 436: ...Index 407 S cont d 1 3 3 1 1 0 1 4 0 3 0 0 1 1 3 1 3 1 0 1 1 1 0 1 3 1 0 1 2 ...
Страница 440: ......