No "RANDBETWEEN" on Excel 2002? Is there a workaround?

[fishoutofwater]

I want to pick an item from a list that is in cells a1 through a7. I know how to do this with RANDBETWEEN(), but as weird as it sounds, when I look at the functions using shift-f3, there is no RANDBETWEEN

Is this possible? I know my excel is old, but that old?

So, since I only seem to have RAND is there a way to pick from my list?

 

[GlennUK]

How about:
=INT(1+RAND()*6.99)

and use it like:
=INDEX(A1:A7,INT(1+RAND()*6.99))

?

 

[VoG]

Tools > Add-Ins > tick Analysis Toolpak > click OK.

 

[anandvarma]

try this

=TRUNC(RAND()*(High-Low)+Low)