TI-83 Plus CellSheet™ Application
Page 41
Using the IF Function
In an IF function, the IF statement evaluates to true or false. The
THEN command is executed if the IF statement is true; the ELSE
command is executed if the IF statement is false.
When you need to use an IF function in a spreadsheet, press
¡ V
, and then select
If(
from the
FUNCTIONS
menu. The
IF function in the CellSheet ™ application is not the same as the
IF function in the TI
83 Plus catalog. (The IF function in the
catalog is for programming.)
•
The condition statement (the IF statement) can contain cell
references, values, or variables.
•
The command statements (the THEN and ELSE statements)
can contain a values or expressions.
•
The operator symbols are available from the
TEST
menu (
\
)
=If(A3
d
d
100,100,0)
Note
The CellSheet application does not support nested functions (a
function within a function).
Condition
statement
Command (ELSE)
statement
Command (THEN)
statement
