View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default HELP with the RAND() Function!!!!!!

daddylonglegs wrote:
Wrote:
..... And why write RAND()*899999999+100000000 when RAND()*999999999
would do just as well?


surely those 2 are not equivalent?


You are right.

The first can't return a value below 100000000


..... Which is wrong, by the way, based on the intent.

whereas the second could return a value as low as zero


..... Which I believe is closer to the intent of returning all "one
billion" possibilities. So instead of saying "just as well", I should
have said "more correctly".