Linest Function for data in rows

    [ATTACH=JSON]{"data-align":"none","data-size":"full","title":"gg.png","data-attachmentid":1218316}[/ATTACH]
    I am trying to fill out my data (year after 2003 or year before 1997) using linear regression. I have been trying
    =LINEST(H2:N2,H1:N1)
    or
    {=LINEST(H2:N2,H1:N1)}


    but it is returning only
    #value!


    Is there anyway I can use linear regression using only formulas...?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login