Casio CLASSPAD 330 3.04 Uživatelský manuál stáhnout pdf (Strana 762)

Cell-Calculation - cellif

Function: Evaluates an equality or inequality, and returns one of three different expressions

based on whether the equality/inequality is true (expression 1), false (expression

2), or inconclusive (expression 3).

With this function, the equality/inequality can include a string as in the following

example: cellif(A1="Red", 0,1,2).

Syntax: cellif(equation, expression 1, expression 2, expression 3)

cellif(inequality, expression 1, expression 2, expression 3)

Example: For each value in cells A1 through A10, to display “Big” in the neighboring

B-column cell for values of 5 and greater, and “Small” for values less than 5:

(=cellif(A15,"Big","Small"))

• Expression 3 is optional for both equation and inequality.

Cell and List Calculations

Žádné komentáře

Casio CLASSPAD 330 3.04 Uživatelský manuál Strana 762