View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
expect_ed expect_ed is offline
external usenet poster
 
Posts: 53
Default 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?