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

POLY

 

Syntax: @POLY(X, ...)

X = a numeric value
... = coefficients of the polynomial in decreasing order of degree (i.e., tex2html_wrap_inline16292 , tex2html_wrap_inline16294 , ...)

@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:

displaymath16290

@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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999