problem with REGLINP func.

[Marcin Kowalewski]

Hi
REGLINP func (linear regresion function) should return two values:
m and b
in my case REGLINP return (display )only one value:m
how to get second value: b

please help me

 

[Harlan Grove]

REGLINP func (linear regresion function) should return two values:
m and b
in my case REGLINP return (display )only one value:m
how to get second value: b

There is no built-in REGLINP function in English versions of Excel, so I guess
this is the Polish equivalent of the English LINEST function. If so, then you
must select a multiple area range and enter an *array* formula calling REGLINP
into that multiple cell range. Alternatively, INDEX(REGLINP(..),1,1) should give
the slope, and INDEX(REGLINP(..),1,2) should give the intercept.