Getting negative random numbers - HELP!

[Guest]

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

 

[Guest]

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?

 

[Biff]

See this:

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

Biff

 

[Guest]

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.