Hi,
There are two types of random number generators (RNG) in MS EXCEL :-
1) Rnd ---- Please ignore this, because it is a flawed/bad RNG (https://www.montecarloexceladdin.com/mersenne-twister-pseudorandom-number-generator-algorithm )
2) RAND() ----- May I know how to apply this RNG directly into Excel Macro VBA codes ? I would like to use the random numbers to do MONTE CARLO simulations.
Your reply would be much appreciated.
Cheers
James
There are two types of random number generators (RNG) in MS EXCEL :-
1) Rnd ---- Please ignore this, because it is a flawed/bad RNG (https://www.montecarloexceladdin.com/mersenne-twister-pseudorandom-number-generator-algorithm )
2) RAND() ----- May I know how to apply this RNG directly into Excel Macro VBA codes ? I would like to use the random numbers to do MONTE CARLO simulations.
Your reply would be much appreciated.
Cheers
James