title: Array formula on Excel for Mac
body: <p>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. </p>
  
  <p><em>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 <kbd>Fn</kbd> <kbd>Ctrl</kbd> <kbd>Alt</kbd> <kbd>Cmd</kbd> <kbd>Return</kbd>!)</em></p>
  
  <p>Finally, <strong><em>I found a solution here on stack overflow!</em></strong>  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 - <kbd>F2</kbd>, <kbd>CTRL</kbd>+<kbd>SHIFT</kbd>+<kbd>ENTER</kbd>. </p>
  
  <p>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!</p>
  
  <p><strong>The solution:</strong> select the range, press <kbd>CONTROL</kbd>+<kbd>U</kbd> and then press <kbd>⌘</kbd>+<kbd>RETURN</kbd>.</p>
  
  <p>Here is the link to the original post:
  <a href="https://stackoverflow.com/questions/1022766/excel-formulas-giving-value-error-when-ported-to-mac#7754603">Excel formulas giving #VALUE! error when ported to Mac</a></p>