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