Random number in Excel

M

Mike Brannigan [MSFT]

rbud said:
How can I generate a random number in Excel 2002?
Click to expand...

Look in the Help for the RAND function

--
Regards,

Mike
--
Mike Brannigan [Microsoft]

This posting is provided "AS IS" with no warranties, and confers no
rights

Please note I cannot respond to e-mailed questions, please use these
newsgroups
 
O

Opinicus

rbud said:
How can I generate a random number in Excel 2002?
Click to expand...

From Excel Help:

"To generate a random real number between a and b, use
RAND()*(b-a)+a"

RAND() returns a random number between 0 and 1.

There's also a RANDBETWEEN(bottom,top) function that does
the same thing as RAND()*(b-a)+a but to use it you have to
install the statistical plugins (or something like that).
 
J

John Ski

Subject: Random number in Excel
From: "=?Utf-8?B?cmJ1ZA==?=" [email protected]
Date: 5/7/2004 12:01 PM Eastern Daylight Time
Message-id: <[email protected]>

How can I generate a random number in Excel 2002?
Click to expand...
A quick search of "Excel Help" will show you how to use the RAND function.

HTH,
John
"Any sufficiently advanced technology is indistinguishable from magic"
***Arthur C. Clarke***
 
O

Opinicus

I'd like to expand on the original question a bit.

How do I generate a string of n random alphanumeric
characters in the range 0-9, A-Z, a-z inclusive?

For example when F9 is pressed the function should return a
string like 0Za4bjkMM8ic when the designated string length
is 12.

Is possible?
 
Top