Excel Linear Trendline Query

Originally Posted by shg

      ----------B----------- ---C--- ---D--- --E--- --F--- --G--- --H--- --I---
  2                          0.59786 1.79524                                   
  3                                                                            
  4   Time                         1     2.5      4   4.75    7.2    7.9    8.5
  5   Value                        2       5      4      3      7      4      9
  6   Linear Trendline Value  2.3931  3.2899 4.1867 4.6351 6.0998 6.5183 6.8771

The formula in C2:D2 is

=LINEST(C5:I5, C4:I4)

It MUST be confirmed with Ctrl+Shift+Enter.

In C6 and copied across,

=$C$2*C4 + $D$2

See Help for LINEST.

Thank for that. What exact formula do you have in box D2? Unable to reconcile your figure. Again, thanks in advance.

Originally Posted by shg

Do you have what you need?

If not, do you want to continue here or at MrExcel?

Either way, please read the forum rules about cross-posting.

I have what I need. Thanks for your assistance.