How can I get the LINEST function in Excel to return more than just slope?

[johnhuntsman]

I figured there ought to be some Excel savvy people here. Anyway I can't seem to get the LINEST function in Excel to return anything other than slope. I provide it with y-values, x-values, and say true to constant and stats. All it gives me back is a slope. Maybe I'm being vague, just ask if you need any other information but I don't know why it won't give me back things other than slope.

 

[SammyS]

I figured there ought to be some Excel savvy people here. Anyway I can't seem to get the LINEST function in Excel to return anything other than slope. I provide it with y-values, x-values, and say true to constant and stats. All it gives me back is a slope. Maybe I'm being vague, just ask if you need any other information but I don't know why it won't give me back things other than slope.

It's been some time since I've used that feature! But it does work.

Do you know how to use the 'array' feature of Excel?

Look over all the help Excel gives for the LINEST function and for arrays.

 

[johnhuntsman]

I managed to figure it out snooping around Excel's help. Thanks : D