CALC.sumproduct(2DArray)
CALC.ceiling(number, significance)
CALC.combin(totalnumber, groupnumber)
CALC.floor(number, SIgnificance)
CALC.quotient(numerator, denominator)
CALC.round(number, num_digits)
CALC.rounddown(number, num_digits)
CALC.roundup(number, num_digits)
CALC.seriessum(x, n, m, coefficients)
CALC.subtotal(functionnumber, array)
Multiplies corresponding components in the given arrays and returns the sum of those products. 2Darray is the array of arrays which are to be multiplied.
Example
CALC.sumproduct([[1,2,3],[2,1,2],[3,3,1]]);
// returns 18
| << CALC.sumif(Array1, ConditionString, array2) | © 1996-2013 InetSoft Technology Corporation (v11.4) | CALC.sumsq(Array) >> |