How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1842
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

Trouble with Linest function: can't seem to get array to

Customer Question

Trouble with Linest function: can't seem to get array to display. Missing something in the steps.
JA: What kind of computer do you have?
Customer: Sorry, Mac ... I just upgraded to Office 2016 and am now having this problem.
JA: Have you installed any updates recently?
Customer: Not since the upgrade a few weeks ago.
JA: Anything else you want the Microsoft Office expert to know before I connect you?
Customer: Need to figure this one out! Have a report due.
Submitted: 1 month ago.
Category: Microsoft Office
Customer: replied 1 month ago.
Can enter the function just fine. Problem is in getting array set up and displaying the stats. Simple mx+b will do, don't need the full set of stats but that would be helpful.
Expert:  The-PC-Guy replied 1 month ago.

yea the linest function works a little bit differently from most functions. I can help you.

Would you like to do a remote session it would be easiest to just show you.