13-7-14

Cell and List Calculations

S List-Calculation - percent

Function: Returns the percentage of each value in the range of specified cells, the sum of which is 100%.

Syntax: percent(start cell:end cell)

Example: To determine the percentage of the values in cells B1 through B4, and input the result in cell A1:

S List-Calculation - polyEval

Function: Returns a polynomial arranged in descending order. The coefficients correspond sequentially to each value in the range of specified cells.

Syntax: polyEval(start cell:end cell[,start cell:end cell] / [,variable])

Example: To create a second degree polynomial with coefficients that correspond to the values in cells B1 through B3, and input the result in cell A1:

20090601