选择范围，按CONTROL+U，然后按⌘+RETURN.

I need to call LINEST in Excel 2011 for Mac, I would say - this was a detective story. My laziness, my curiosity, all was here! I had a homework from university course to use LINEST.

I even stopped trying to do so on MAC, because after googling I could not find any solution how to do it. (I have tried EACH AND EVERY combination of Fn Ctrl Alt Cmd Return!)

Finally, I found a solution here on stack overflow! I want to mention it again, as it was a long time I spent looking for the solution. I have spent 4 days outside of home, to use just windows PC where it is easy as a pie - F2, CTRL+SHIFT+ENTER.

If you want to check if I tell truth - go to HELP in Excel for Mac, type array formula, find LINEST and look at the solution combination!

The solution: select the range, press CONTROL+U and then press ⌘+RETURN.

Here is the link to the original post: Excel formulas giving #VALUE! error when ported to Mac

Select the range, press CONTROL+U and then press ⌘+RETURN.