Random number generator?

[eHanSolo]

Hi guys,

does anyone know if there's a formula that keeps generating random numbers??? Many thanks!

E

 

[Molby]

You can use =RANDBETWEEN(1,200) to specify a random number between two numbers you choose (in this case 1 and 200). You can just click on F9 to get refreshing it.

 

[01Patrik]

Never heard about RANDBETWEEN - sounds like a UDF based on RAND to me? I doesn't exist on any of my machines (2000, XP) anyway.


However, you can use =RAND(), which selects a random number between 0 and 1. To get it in the correct range / format, multiply with a number of your choice, and combine with ROUND (or ROUNDUP, ROUNDDOWN).

Example:

=roundup(RAND()*100)

for a number between 1-100.

// Patrik

 

[gizmo1973]

Randbetween is an Excel Add In
It won't appear on you machine until you add it in
It's on the Analysis Tool Pack - VBA

Regards, Phil

"If in doubt, hit it with an end user!

 

[eHanSolo]

wow...thank you guys!!!!


E