Random Number Generator

[CarlCarlos]

Dear all,

I am trying to create a Random number generator that only includes the numbers:

0, 1, 3 and 5

Can anyone please help?

 

[shg]

=choose(randbetween(1,4), 0, 1, 3, 5)

 

[CarlCarlos]

Thank you for this but it comes back:

#NAME?

 

[Dryver14]

randbetween started in 2007 are you using an earlier version of excel?

 

[VoG]

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

 

[CarlCarlos]

I am using an older version of Excel,

And i do not have access to the analysis Tool pack as my company have not installed it

 

[CarlCarlos]

Thank you both, IT have just installed analysis tool pack and the RandBetween works perfectly.

Thank you

 

[shg]

This doesn't require it:


=lookup(rand(), {0,25,50,75)%, {0,1,3,5})