<tbody> </tbody> |
<tbody>
</tbody>
Above is the data I have in columns D and F
If I use :
Code:
'=LINEST(F4:F23,D4:D23,,TRUE)
If I use:
Code:
'=SLOPE(F4:F23,D4:D23)
But if I use:
Code:
'=SLOPE(IF(ISNA(D4:D23),"",D4:D23),IF(ISNA(F4:F23),"",F4:F23))