Mac版Excel上的阵列公式 [英] Array formula on Excel for Mac

问题描述

我需要在Mac的Excel 2011中调用LINEST，这是一个侦探性的故事.我的懒惰，我的好奇心都在这里！ 我有大学课程的作业，使用LINEST.

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.

我甚至停止尝试在MAC上这样做，因为在进行谷歌搜索之后，我找不到任何解决方法. (我已经尝试了 Fn Ctrl Alt Cmd Return 的每种组合！ )

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!)

最后， 在堆栈溢出的地方我找到了一个解决方案！ 我想再次提一下，因为我花了很长时间寻找解决方案.我已经在家外呆了4天，只使用Windows PC轻松做馅饼- F2 ， CTRL + SHIFT + ENTER .

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.

如果您想检查一下我是否讲对了-在Excel for Mac中转到HELP，键入数组公式，找到LINEST并查看解决方案组合！

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!

解决方案:选择范围，按 CONTROL + U ，然后按⌘ + 返回.

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

以下是原始帖子的链接: 提供#VALUE的Excel公式！移植到Mac时出错

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

推荐答案

---

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

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

这篇关于Mac版Excel上的阵列公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！