Formula Engine Reference Guide
 

 

Back to Class Index

 

POLY(X, ...)

Description
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