Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Pittsford,NY
    Posts
    874
    Thanks
    517
    Thanked 35 Times in 27 Posts

    Is there a difference between Excel 2007 & 10 re: this function

    A friend who uses Excel 2010 sent me a workbook. I use Excel 2007.
    On 1 sheet I get #NAME? in all the cells.

    The formula that fails in 2007 is:

    =_xlfn.COVARIANCE.P('Daily Returns'!B4:B254,'Daily Returns'!$B4:$B254)/_xlfn.VAR.P('Daily Returns'!$B4:$B254)

    Can anyone help me with the resolution?

    Thanks,
    Dick

    PS,
    That formula works for him in Excel 2010.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    The COVARIANCE.P function is NOT available in Excel2007.

    zeddy

  3. The Following User Says Thank You to zeddy For This Useful Post:

    Dick-Y (2013-03-18)

  4. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    ..it's available in Excel2010 and Excel2013


    zeddy

Posting Permissions

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