Command

Description

 

 

CellMedian(

Returns the median value in a specified range of cells.

(Median of Cells)

Input Key Operation: 5(CELL)4(Med)

 

Syntax: CellMedian(start cell:end cell[)]

 

Example: =CellMedian(A3:C5)

 

Returns the median value of the data in cell range A3:C5.

 

 

CellSum(

Returns the sum of the data in a specified range of cells.

(Sum of Cells)

Input Key Operation: 5(CELL)5(Sum)

 

Syntax: CellSum(start cell:end cell[)]

 

Example: =CellSum(A3:C5)

 

Returns the sum of the data in cell range A3:C5.

 

 

CellProd(

Returns the product of the data in a specified range of cells.

(Product of Cells)

Input Key Operation: 5(CELL)6(Prod)

 

Syntax: CellProd(start cell:end cell[)]

 

Example: =CellProd(B3:B5)

 

Returns the product of the data in cell range B3:B5.

 

 

kSpreadsheet Mode Command Example

This example inputs the special Spreadsheet mode formula CellSum( into cell C1 in order to calculate the sum of all the data in cell range A1:B5. It is assumed that there is already data in the cell range A1:B5.

1. Move the cell cursor to cell C1 and then perform the following operation. !.(=)5(CELL)5(Sum)

Jav(A)b3(:)al(b)f)

•You can perform the following operation, which uses the GRAB function (page 9-12) and CLIP function (page 9-7) in place of the underlined part in the above operation.

J1(GRAB)4(TOP←) (Enters the GRAB mode and moves the cursor to A1.)

!i(CLIP)ecccc (Specifies the selection range for the CLIP function.)

w)

2. Press w to finalize input of the formula.

9-20