Sharp ZAURUS ZR-5000 Specifikace stáhnout pdf (Strana 355)

100

101

Logical functions

Logical functions let you use conditions in building

formulas. Use them when you want the outcome of a

computation or a returned value to determine some

other value assignment or to control the sequence of

operations. You can also use logical functions to

determine values and control operations when error

conditions occur and when special input types are used.

Using logical functions to test for such conditions helps

you avoid errors which might otherwise ripple through-

out the spreadsheet.

AND(values...)

Evaluates each of the arguments. Returns TRUE if

all the arguments are TRUE; returns FALSE if one

or more is FALSE.

Example: AND( TRUE(), TRUE(), FALSE() )

returns FALSE.

FALSE()

Returns the logical value FALSE.

IF(cond, true,

false

)

Evaluates the cond expression. If cond is true, it

evaluates and returns the value of true part.

Otherwise, it evaluates and returns the value of

false

part or FALSE if

false

part is omitted.

Example: IF( B5>5, “Bigger”, “Smaller” ) returns

“Bigger” if B5 is greater than 5, and “Smaller”,

otherwise.

IF( A1, “OK” ) returns “OK” if A1 is TRUE and

FALSE, otherwise.

IF( B1>A1, 24*(B1-A1), 24-24*(A1-B1)) is an

example of a more complicated IF function.

NOT(value)

Reverses the logical value of its argument.

Example: NOT( FALSE() ) returns TRUE.

OR(values...)

Returns TRUE if one or more of the arguments is

TRUE; returns FALSE if all arguments are FALSE.

Example: OR( FALSE(), TRUE() ) returns TRUE.

TRUE()

Returns the logical value TRUE.

1 2 ... 350 351 352 353 354 355 356 357 358 359 360 ... 528 529

Komentáře k této Příručce

Žádné komentáře

Sharp ZAURUS ZR-5000 Specifikace Strana 355

Komentáře k této Příručce

Související produkty a manuály pro Tablety Sharp ZAURUS ZR-5000