I am trying to find out how to get the results of the enclosed file the moderator had posted for someone. The issue is with the cells (B12:E12). How were these result obtained. I tried it myself in cell B22 but was only able to get the first part of the equation and I do not know how to get the rest. Does anybody please have any ideas on how this was done.
I am new to these forums and I do not how to post a link to the discussion that contained the Excel document, otherwise I would have.
Thanks, Steven
It's an array formula, meaning it MUST be confirmed with Ctrl+Shift+Enter, not just Enter. (With all four cells selected and the cursor in the formula bar, hold down Ctrl and Shift, then press Enter.) You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.
If you look at help for LINEST, you'll find it can returns other parameters of the fit as well.
Just copy the address from the browser address bar and paste it into the thread.... I do not how to post a link to the discussion ...
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
It works!!!
Thanks so much,
Steven
You’re welcome. Would you please mark the thread as Solved?
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks