RAND() generates negative values???
 

Office 2007 - Even though the description says:
"Returns a random number greate than or equal to 0 and less than 1, evenly
distributed (changes on recalculation)."
When I enter the formula and extend the cell down the column I get negative
values.
What gives?

RAND() generates negative values???
 

Hi,

If =RAND() is generating negatives then something else is going on. Post the
formula you used.

Do you have any event code running on the sheet?
Do you have any formatting in the cells?

Mike

"expect_ed" wrote:

Office 2007 - Even though the description says:
"Returns a random number greate than or equal to 0 and less than 1, evenly
distributed (changes on recalculation)."
When I enter the formula and extend the cell down the column I get negative
values.
What gives?

RAND() generates negative values???
 

I just tested RAND in Excel 2007 SP1 through 20 million iterations and did
not get a single negative number.

--
Biff
Microsoft Excel MVP


"expect_ed" wrote in message
...
Office 2007 - Even though the description says:
"Returns a random number greate than or equal to 0 and less than 1, evenly
distributed (changes on recalculation)."
When I enter the formula and extend the cell down the column I get
negative
values.
What gives?