Mac上的Excel数组公式

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.

我想说的是，我需要在Excel 2011中为Mac调用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!)

我甚至不再尝试在MAC上这样做，因为在谷歌上搜索之后，我找不到任何解决方法。(我试过Fn Ctrl Alt Cmd返回的每一个组合!)

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.

最后，我在stack overflow上找到了一个解决方案!我想再提一次，因为我花了很长时间来寻找解决方案。我在外面呆了4天，只使用windows PC，它就像一个馅饼——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!

如果你想看看我说的是不是真的-去帮助Mac的Excel，输入数组公式，找到最线，看看解决方案组合!

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

解决方案:选择范围,按控制+ U,然后按⌘+回报。

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

这里有链接到原来的帖子:Excel公式给出#VALUE!当移植到Mac时发生错误

4 个解决方案

#1

This doesn't seem to work in Mac Excel 2016. After a bit of digging, it looks like the key combination for entering the array formula has changed from ⌘+RETURN to CTRL+SHIFT+RETURN.

这在Mac Excel 2016中似乎行不通。经过一点挖掘,它看起来像组合键输入数组公式已经从⌘+ CTRL + SHIFT +返回返回。

#2

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

选择范围,按控制+ U,然后按⌘+回报。

#3

Found a solution to Excel Mac2016 as having to paste the code into the relevant cell, enter, then go to the end of the formula within the header bar and enter the following:

找到一个Excel Mac2016的解决方案，将代码粘贴到相关的单元格中，然后进入标题栏内的公式的末尾并输入以下内容:

Enter a formula as an array formula Image + SHIFT + RETURN or CONTROL + SHIFT + RETURN

输入一个公式作为数组公式图像+移位+返回或控制+移位+返回

#4

-1

Select the desired range of cells
选择所需的单元格范围
Press Fn + F2 or CONTROL + U
按Fn + F2或CONTROL + U
Paste in your array value
粘贴数组值
Press COMMAND (⌘) + SHIFT + RETURN
按命令(⌘)+ SHIFT +返回

#1