View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
DennisE DennisE is offline
external usenet poster
 
Posts: 66
Default Random Number Generator

Can an Excel guru answer this?

Knowledge Base Article 44738, states that the expression
(NOW()*100000 - INT(NOW()*100000))
can be used as an alternative to the RAND() function for generating random
numbers. My question is, when Excel evaluates the above formula in any one
instance, is the value of the NOW() function on the left going to be the same
as that on the right, or are they going to be different cause they are each
evaluated a microsecond apart in time?

-- Dennis Eisen