Linest Array vertical answer return

B

Baffeled

I am trying to perform a rolling linest function, and as the formula returns
2 answers I need them to be on top of each other, so as I drag the formula
across it gives me both answers. I have selected two cells above each other
but the formula returns the wrong value for the constant C.

So below each colum of data I need to produce a linest function to return
the Mx+C (M and C), then be able to drag this accros each colum to return the
linest function for each colum.
 
D

Dave Curtis

Hi,

Have you tried extracting the individual LINEST results from the array?

=INDEX(LINEST(B1:B10,A1:A10,TRUE,TRUE),1,1) will give you the gradient, and
=INDEX(LINEST(B1:B10,A1:A10,TRUE,TRUE),1,2) will give you the intercept.

Alternatively, you could just use the SLOPE and INTERCEPT functions.

Dave
 
B

Baffeled

Thank you, works perfect!

Dave Curtis said:
Hi,

Have you tried extracting the individual LINEST results from the array?

=INDEX(LINEST(B1:B10,A1:A10,TRUE,TRUE),1,1) will give you the gradient, and
=INDEX(LINEST(B1:B10,A1:A10,TRUE,TRUE),1,2) will give you the intercept.

Alternatively, you could just use the SLOPE and INTERCEPT functions.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linest function for curve 2
Variable Data in Equations 1
LINEST multiple known_x's separated arrays 5
LINESt 1
Reversed Array 10
Linest 0
LINEST function - data range 2
LINEST containing selection 0

Top