Linest function: data not being selected in formula
 

Since upgrading from 2002 to 2003 a spreadsheet that worked is now not
working correctly. The formula is not calculating the selected data
correctly. The formula is

=INDEX(LINEST(D12:O16,D37:O41,,FALSE),1)

Excel is having a problem selecting data on multiple rows. A test has been
carried out when the data was moved into one column or one row and it worked.
It appears excel is now only taking into account the first row of data.

Is there an option that needs to be selected for it to work? The help files
were compared between the versions of excel and there is no difference. The
objective of the formula is to calculate a regression line.

If you require more information please ask.

Thank you

Nathan

Linest function: data not being selected in formula
 

Please can anyone help me solve this problem.

Use linest function to estimate what A,B,C & D will be, Compare them.

Y= a+bx+cx^2+dx^3

assum x=0, x=1, .................. x= 100

Calculate the corresponding value of Y. Choose any coefficient for the
constant.

Thanks and regards,
Dave





"NathanG" wrote:

Since upgrading from 2002 to 2003 a spreadsheet that worked is now not
working correctly. The formula is not calculating the selected data
correctly. The formula is

=INDEX(LINEST(D12:O16,D37:O41,,FALSE),1)

Excel is having a problem selecting data on multiple rows. A test has been
carried out when the data was moved into one column or one row and it worked.
It appears excel is now only taking into account the first row of data.

Is there an option that needs to be selected for it to work? The help files
were compared between the versions of excel and there is no difference. The
objective of the formula is to calculate a regression line.

If you require more information please ask.

Thank you

Nathan