20090601
S
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.
13-7-6
Cell and List Calculations
Summary of Contents for ClassPad 330
Page 11: ...20060301 20090601 ClassPad 330 ClassPad OS Version 3 04 ...
Page 277: ...20060301 3 3 10 Storing Functions 3 Tap AND Plot OR Plot ...
Page 779: ...20090601 S Graph Line Clustered C S Graph Line Stacked E 13 9 2 Graphing ...
Page 780: ...20090601 S Graph Line 100 Stacked F S Graph Column Clustered G 13 9 3 Graphing ...
Page 781: ...20090601 S Graph Column Stacked I S Graph Column 100 Stacked J 13 9 4 Graphing ...
Page 782: ...20090601 S Graph Bar Clustered K S Graph Bar Stacked 9 13 9 5 Graphing ...