Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RAND() Fix (Excel 2003)

    Hello,
    I see that Microsoft posted a fix for RAND(),RANDBETWEEN(), SLOPE(), INTERCEPT(), FORECAST(), and STEYX()
    Excel 2003 Update: KB834691 . I know that you could have called to get the patch, but I didn't have the time or money to spend on the phone from DK. My question: what about the other versions of Excel. I'm still using 2002. I do run quite a few simulations. Is there a fix for 2002?

    Are the problems with SLOPE(), INTERCEPT(), FORECAST(), and STEYX() only in 2003?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: RAND() Fix (Excel 2003)

    Microsoft re-wrote the code behind the RAND() and other statistical functions in Excel 2003, so this error is only present in Excel 2003. As you are using 2002 there is no fix.

    MSKB 828888 details the updates made in 2003.

Posting Permissions

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