20060301
13-6-14
Using the Action Menu
u
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:
u
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:
To Next Page
Loading...
