Thread: How to get repeatable Excel RAND sequence?
View Single Post
  #12  
Old March 26th, 2010, 09:34 PM posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_]
external usenet poster
  
Posts: 184
Default How to get repeatable Excel RAND sequence?
Oops! I forgot to include the aux program dMod()

Function dMod(x, y)
dMod = x - Int(x / y) * y
End Function


x = dMod(x * a + b, k) / k

= = = = = = =
HTH :)
Dana DeLouis