Re: Trouble with RANDBETWEEN

Could we say that if we wanted to write out the rule for performing this
particular type of calculation, that if we wanted to generate a random number
(MyValue) between two other numbers (x, y) and y>x :
MyValue = Int( ( ( (y-x)+1)*RND() ) + (x-1) )

This should work for most positive random numbers that we wish to find
random numbers between, right?


"JE McGimpsey" wrote:

> Modify Ian's code slightly:
>
> MyValue = Int(3 * RND()) + 9
>
>
> In article <99C12163-53C6-4DB3-A24E-0333A862FF4B@xxxxxxxxxxxxx>,
> "GSpline" <GSpline@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > Thanks for the info, Ian. I am not having much luck with this particular
> > question in the online help. What you posted is close to what I am looking
> > for, but I am needing the random value to be between two numbers other than
> > 1, for example a random number between 9 and 11. I will keep plugging away,
> > it looks like this gives me a starting point now.
>
.

Relevant Pages

  • Re: Swiss FIBS Party 2006
    ... in my calculation the champ loses $700 in 22 events or $31.80 per ... smallest bit of luck already results in several 1000s of $ profit ... winchance means without gambling on luck and there the winchance is ... the effect we see here is similar to any kind of lottery, only in lotto ...
    (rec.games.backgammon)
  • Re: Stan Ayeroff anybody?
    ... I have had several of his books for years - many of his arrangements ... performing before an audience. ... Glenn Gould's proposition regarding the proper ratio of audience to ... Good luck ...
    (rec.music.classical.guitar)
  • Re: Evaluate in field, like excel?
    ... On 2008-02-21 21:20:45 -0800, Helpful Harry ... excel, so that the user is able to perform simple calculation in a ... I recommend exploring the list of functions and operators available in the online Help. ... If you write a calculation using Evaluate, a user can type 2+3 in the field and the result will be 5. ...
    (comp.databases.filemaker)
  • Re: Evaluate in field, like excel?
    ... the list of functions and operators available in the online Help. ... If you write a calculation using Evaluate, a user can type 2+3 in the ... Member Filemaker Business Alliance ... file faster than calling it up from Filemaker itself? ...
    (comp.databases.filemaker)
  • #Error
    ... eg. ABCDEF ... The width column then produces the following error: #Error for this entry. ... All I want to be able to do is allow the calculation ... No luck with this. ...
    (microsoft.public.access.queries)
Loading