Getting negative random numbers - HELP!
 

I must be crazy, but I am using the RAND() function and it occasionally
generates a negative number. I cannot find any information on this - by
definition it should only generate numbers between 0 and 1.

Any suggestions?

Thanks in advance.

Susan Forson

Getting negative random numbers - HELP!
 

You are correct, by definition it should return a (positive) value between 0
and 1.

Are you certain the formula in the cell is
=RAND()
if it has any other paramters, that may be affecting your results?

"SusanForson" wrote:

I must be crazy, but I am using the RAND() function and it occasionally
generates a negative number. I cannot find any information on this - by
definition it should only generate numbers between 0 and 1.

Any suggestions?

Thanks in advance.

Susan Forson

Getting negative random numbers - HELP!
 

See this:

http://support.microsoft.com/kb/834520

Biff

"SusanForson" wrote in message
...
I must be crazy, but I am using the RAND() function and it occasionally
generates a negative number. I cannot find any information on this - by
definition it should only generate numbers between 0 and 1.

Any suggestions?

Thanks in advance.

Susan Forson

Getting negative random numbers - HELP!
 

Great find! No wonder I couldn't duplicate it here (must have refreshed a
sheet 40 times trying) - I'm up to date on hotfixes.

"Biff" wrote:

See this:

http://support.microsoft.com/kb/834520

Biff

"SusanForson" wrote in message
...
I must be crazy, but I am using the RAND() function and it occasionally
generates a negative number. I cannot find any information on this - by
definition it should only generate numbers between 0 and 1.

Any suggestions?

Thanks in advance.

Susan Forson