After a bit of digging, it looks like the key combination for entering the array formula has changed from ⌘+ RETURN to CTRL+ SHIFT+ RETURN. This doesn’t seem to work in Mac Excel 2016. The solution: select the range, press CONTROL+U and then press ⌘+RETURN.Įxcel formulas giving #VALUE! error when ported to Mac How to solve this problem? Solution no. 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! I have spent 4 days outside of home, to use just windows PC where it is easy as a pie – F2, CTRL+SHIFT+ENTER. (I have tried EACH AND EVERY combination of Fn Ctrl Alt Cmd Return!)įinally, 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 even stopped trying to do so on MAC, because after googling I could not find any solution how to do it. I had a homework from university course to use LINEST. I need to call LINEST in Excel 2011 for Mac, I would say – this was a detective story.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |