Hi, I am using Excel 2016 on a 2018 MacBook Pro and I have been trying to use the LINEST function to get information from a dataset. I have used LINEST before on other machines without issue. Whenever I use the function now however, it always returns a value for M and the other values contain #VALUE!
I found this error while doing data processing for a lab report so I tested it on a blank, new and simple file to see if the error repeats itself. On the lab report a value for M and C is returned and on the test file only a value for M is returned, with the others being errors.
I use command + enter to fill the cells, and the cells do fill, only with this error. I have tried command + option + enter and various other combinations and command + enter seems to be the only one which at least fills the cells, be it not with the correct outputs.
I have noticed that when navigating the output from the function, the data being read from set of cells box is not the same, the top left box for instance will read cells A1 to A10, the top right will read B1 to B10, the bottom left will read A2 to A11 and bottom right reads B2 to B11. This would explain why my lab report has a C value returned (as the cells next to the cells used to calculate the information are also filled with data). Basically I think the problem is that Excel Mac 2016 has an issue with reading the correct cells with the LINEST function, as everything works normally with Excel 2011 on an older Mac of mine.
Any help with something I am doing wrong would be much appreciated. Thank you.
Bookmarks