Back to Class Index
POLY(X, ...)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) =( 3X2+4X+5). Parameters X A numeric value ... coefficients of the polynomial in decreasing order of degree (i.e., , , ...) Examples POLY(2, 3, 4, 5) = 25 where (3(22) + 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 |