Random number in Excel

[rbud]

How can I generate a random number in Excel 2002?

 

[Mike Brannigan [MSFT]]

How can I generate a random number in Excel 2002?

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

 

[Opinicus]

How can I generate a random number in Excel 2002?

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).

 

[Robert B. Clark]

How can I generate a random number in Excel 2002?

=RAND()

returns an evenly distributed random number >=0 and <1.

 

[John Ski]

Subject: Random number in Excel

From: "=?Utf-8?B?cmJ1ZA==?=" (e-mail address removed)
Date: 5/7/2004 12:01 PM Eastern Daylight Time
Message-id: <[email protected]>

How can I generate a random number in Excel 2002?

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***

 

[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?

 

[Bob I]

The CHAR function is what you are after.