Casio FXCP400 13-4Cell and List Calculations, row, col, count, cellif, Tap the, Tap [Next >>], 4.Tap [Next >>], Syntax: row(cell), Syntax: col(cell)

2.On the menu bar, tap [Calc] and then [Distribution].

•The Distribution Calculation Wizard will appear in the lower half of the display.

3.Tap the vbutton to the right of the second item from the top and then select the desired distribution calculation from the menu that appears.

4.Tap [Next >>].

•This will display a screen with the variable assignments for the range you selected in step 1 of this procedure entered automatically in the input fields as the initial defaults.

5.Enter values for the other variables and then tap [Next >>].

•This displays the calculation results. If there are multiple calculation results, tap Vto view them.

•You can tap $ here to display the distribution graph.6.On the calculation result window, tap the [Output>>] button.7.On the output window, tap [Paste].•This pastes the calculation results in formula format.About DispStat Command

Tapping [Calc] - [DispStat] displays a DispStat window that displays statistical calculation (one-variable, two- variable, regression, test, interval, distribution, or inverse distribution calculations) results after a calculation is performed.

Tip: The DispStat window shows statistical calculation results of the last statistical calculation that was executed using any ClassPad application (except for eActivity). For example, immediately after a calculation is executed using “NormPD” command in the Main application, that calculation result is displayed on the DispStat window, even with the Spreadsheet application. However, note that calculation results produced using a mathematical function, such as “normPDf(”, are not displayed on the DispStat window.

13-4 Cell and List CalculationsUsing the Cell Calculation Functions

Spreadsheet application special functions are included on the [Cell-Calculation] submenu of the [Calc] menu. Selecting a menu item on the [Cell-Calculation] submenu will input the corresponding function into the currently selected cell. This section provides explanations of the functions and input syntax of the cell calculation functions.

Function	Description
row	Function: Returns the row number of a specified cell.
	Syntax: row(cell)
col	Function: Returns the column number of a specified cell.
	Syntax: col(cell)
count	Function: Returns a count of the number of cells in the specified range.
	Syntax: count(start cell[:end cell])
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)

1303 For each value in cells A1 through A5, to display “Big” in the neighboring B-column cell for values of 5 and greater, and “Small” for values less than 5

Chapter 13: Spreadsheet Application 241