Can someone help me with these Slope and Linest Formulas?

[Peter h]

2.535 635.500 2.713 542.744 2.990 850.167 2.740 702.262 2.878 836.877 2.829 828.331 3.160 840.416 2.624 636.037 2.832 740.483 2.617 642.694 2.312 558.547 2.866 903.324 3.057 826.347 2.885 819.429 2.785 811.478 2.841 808.814 2.741 746.532 2.967 869.757 3.240 977.743 2.599 759.444 <tbody> </tbody>

<tbody>
</tbody>

I'm really curious why I'm getting different results from these different formulas. Can someone explain them to me and how they get these numbers?

Above is the data I have in columns D and F

If I use :

'=LINEST(F4:F23,D4:D23,,TRUE)

I get 440.6991

If I use:

'=SLOPE(F4:F23,D4:D23)

I get 440.6991

But if I use:

'=SLOPE(IF(ISNA(D4:D23),"",D4:D23),IF(ISNA(F4:F23),"",F4:F23))

I get .00156 (which is what I think it should be)

 

[Peter h]

I know what I am doing. I got my ranges switched in the last formula. It's calculating X's and Y's inverted to those in the other formulas.

I apologize for the wasted thread.