Syntax: POLY(X, ...)
X = a numeric value
... = coefficients of the polynomial in decreasing order of degree
(i.e., ,
, ...)
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:
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