I have forgotten how this works, but I'm trying to calculate a polynomial value (y = C0 + C1*X + C2*X^2).
I remember the formula is something like this: =sumproduct(A1,B1:B3^{0,1,2})
Where A1 is any value and B1:B3 contains the polynomial coefficients.
However, what I typed above is not correct.
How to?
Bookmarks