Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula in Excel 2003 not working

    Hello Everyone,

    A friend of mine is trying to use the following formula in Excel 2003 and it returns a value of #N/A. The formula works in Excel 2010 and Excel 2007. Here is the formula NEGBINOMDIST(500,500,0.56)
    Does anyone know why it doesn't work in Excel 2003?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    989
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Works for me in Excel 2003 - gives 8.93612E-06.

    Are you sure you don't have a typo as #N/A isn't an expected error - see http://office.microsoft.com/en-us/ex...005209189.aspx

    Can you use 2003's Trace Error and/or Evaluate Formula functions to help track down the issue ?
    Last edited by MartinM; 2011-08-10 at 05:10.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I will try it. I am thinking my Excel version is corrupted and therefore the error. Thanks.

  4. #4
    Super Moderator jwitalka's Avatar
    Join Date
    Dec 2009
    Location
    Minnesota
    Posts
    6,794
    Thanks
    117
    Thanked 799 Times in 720 Posts
    See Correct an NA# error .

    Jerry

Posting Permissions

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