re: Rand function

Susan Hayes wrote...
>I'm trying to get a number between and including 1 and 20
....

=INT(1+20*RAND())

Try: =RANDBETWEEN(1,20)

Good solution, but requires the OP to have the Analysis Toolpak add-in
installed

"Matt" <matthew.clegg@asx.com.au> wrote in message
news:1124322320.042322.113290@o13g2000cwo.googlegroups.com...
> Try: =RANDBETWEEN(1,20)
>

Hello

I'm trying to get a number between and including 1 and 20
i have tried
=RAND()*(20-1)

thank you

Susan

Susan Hayes wrote...
>I'm trying to get a number between and including 1 and 20
....

=INT(1+20*RAND())

Try: =RANDBETWEEN(1,20)

Good solution, but requires the OP to have the Analysis Toolpak add-in
installed

"Matt" <matthew.clegg@asx.com.au> wrote in message
news:1124322320.042322.113290@o13g2000cwo.googlegroups.com...
> Try: =RANDBETWEEN(1,20)
>