Linest() function returns error.

[aryansss]

Hello,

I'm trying to run a simple regression analysis on my Y and X variables but I get this error 'LINEST() function returns error. Please check input ranges again'. I have checked that my columns does not contain any blank cells. What else can be a reason for this? I really need to do this regression. Please help. Below is the link to the data

Transfer - Dropbox

Dropbox is a free service that lets you bring your photos, docs, and videos anywhere and share them easily. Never email yourself a file again!

www.dropbox.com

 

[vmjan02]

'LINEST()

just try linest function instead of 'linest() ' symbol represents a sheet name

 

[joeu2004]

I do not see any LINEST formulas in your example Excel file.
And you did not post the formula that gave you an error.
So there is nothing that anyone can say or do, apart from wild guesses.
Post a link to an Excel file that demonstrates the problem.

Include the LINEST formula that causes the error.

If you cannot include it in the file (because of a syntax error),
at least include it your posting.
Alternatively (better), include it as text in your Excel file.
In either case, present the formula exactly as you typed it
(copy-and-paste from the Formula Bar),
and let us know if you press ctrl+shift+Enter when you typed the formula.