Apple Keynote Guide de l'utilisateur télécharger pdf (Page 122)

122 Chapter 5 Creating Tables

Logical functions determine whether a particular condition is TRUE or FALSE.

This function Returns Examples Notes

AND(x

...) TRUE if all the

arguments are TRUE,

otherwise returns

FALSE

AND(TRUE, TRUE)

returns TRUE

AND(TRUE, FALSE)

returns FALSE

AND(TRUE, 0) returns

FALSE

See note at end of

table.

ISERROR(x) TRUE if x is erroneous,

otherwise returns

FALSE

ISERROR(1/0) returns

TRUE

NOT(x) TRUE if x is FALSE

FALSE if x is TRUE

NOT(TRUE) returns

FALSE

NOT(FALSE) returns

TRUE

Interprets 0 as FALSE

and all other numbers

as TRUE

OR(x

...) TRUE if any argument

is TRUE, otherwise

returns FALSE

OR(TRUE, FALSE)

returns TRUE

OR(FALSE) returns

FALSE

See note at end of

table.

Notes:

Â If an argument of AND or OR is a reference to a cell that doesn’t contain

TRUE or FALSE, the argument is ignored. When you type arguments, rather

than referring to cells for values, zero is interpreted as FALSE, any other number

is interpreted as TRUE, and text strings result in an error.

1 2 ... 117 118 119 120 121 122 123 124 125 126 127 ... 186 187

Commentaires sur ces manuels

Pas de commentaire

Apple Keynote Guide de l'utilisateur Page 122

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Apple Keynote