Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Report :error executing this command (2000 SP3)

    the rate function crashes : rate(5;0; -[1998];[2003];0).
    It works for when -[1998]; =-3 and [2003] = 47 by not when [2003] = 470.

    Why?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report :error executing this command (2000 SP3)

    From the online help for the Rate function:
    <hr>Rate is calculated by iteration. (...) Rate cycles through the calculation until the result is accurate to within 0.00001 percent. If Rate can't find a result after 20 tries, it fails.<hr>
    You can supply a value for the Guess argument if you get an error, e.g.

    Rate(5;0;-[1998];[2003];0;100%)

Posting Permissions

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