How to generate a random number

[Hal Hansen]

In Quattro Pro, @randbetween(1,33) hit enter and you have your number.
I have been looking at the excel help files, can't figure it out.

 

[Alan]

Try
=INT(RAND()*32)
if you dont want a zero to show
=INT(RAND()*31)+1

 

[Frank Kabel]

Hi
in Excel install the Analysis Toolpak addin and use
=RANDBETWEEN(1,33)

 

[Ron Rosenfeld]

In Quattro Pro, @randbetween(1,33) hit enter and you have your number.
I have been looking at the excel help files, can't figure it out.

It's probably the same as the Excel =RANDBETWEEN(1,33) function

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


--ron

 

[RagDyer]

If you don't wish to install the ATP, you can get the same results with this
formula:

=INT(RAND()*33+1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


In Quattro Pro, @randbetween(1,33) hit enter and you have your number.
I have been looking at the excel help files, can't figure it out.

 

[Hal Hansen]

In Quattro Pro, @randbetween(1,33) hit enter and you have your number. I
have been looking at the excel help files, can't figure it out.

Thanks to everyone who responded!!!