Results 1 to 9 of 9

Value of LINEST

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2009
    Location
    Stockholm
    MS-Off Ver
    Excel 2007
    Posts
    11

    Value of LINEST

    Hi All,
    I got problem when using the LINEST function (linear regression). How do one add the value of the slope to a cell?

    I use the code below but I get the #VALUE! message in the cell. The cell's format is General.

       Dim v As Variant
       Dim x As Variant
       Dim Y As Variant
       x = Range("B2:B3")
       Y = Range("D2:D3")
       v = Application.LinEst(Y, x, True, True)
       Worksheets("Sheet1").Range("H1").Value = v
    What is wrong here?

    Cheers!
    Last edited by aner1755; 03-09-2009 at 04:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1