next up previous contents index
Next: POLYCOEF Up: A. Function Reference Previous: PMT   Contents   Index


POLY

Syntax: POLY(X, ...)

X = a numeric value
... = coefficients of the polynomial in decreasing order of degree (i.e., $a_N$, $a_{N-1}$, ...)

POLY returns the value of an Nth-degree polynomial in X. The coefficient arguments may be any combination of numbers, cells containing numbers, or ranges containing numbers. Any non-numeric argument produces an error. The function is given by:

\begin{displaymath}
a_N x^N + a_{N-1} x^{N-1} + \cdots + a_0    ,
\end{displaymath}

POLY(X, 3, 4, 5) =( 3*X**2+4*X+5)

Examples:

POLY(2, 3, 4, 5) = 25, where (3*(2**2) + 4*(2) + 5) = 25

POLY(-1, A1, A2) = 1, where A1 = 2 and A2 = 3 because (2*-1 + 3) = 1

POLY(3, 2, 5, 4, 6) = 117

POLY(-1, -2, -3, -4) = -3

Excel function: N/A


next up previous contents index
Next: POLYCOEF Up: A. Function Reference Previous: PMT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003