A

#### aberdonian

I am wondering if I can somehow pull the coefficients from the trendline

equation and display them in cells separately, e.g if the equation is

y = -5.21250E-21x5 + 2.35760E-17x4 + 7.99900E-13x3 - 4.69050E-08x2 -

1.56030E-03x + 6.86378E+01

I want the coefficients to be displayed in separate cells

-5.21250E-21

2.35760E-17

7.99900E-13

-4.69050E-08

-1.56030E-03

6.86378E+01

I am quite sure this can be done, since these coefficients are a

calculation, but how to do that? Correct me if I am wrong.

Thanks in advance.

Regards,

Excel User