How can the results of the RAND and RANDBETWEEN functions become non-volatile(keeping the generated numbers fixed and not automatically recalculating) each time a new RAND or RANDBETWEEN command is entered into another cell?
In this case I would suggest you to take help of a VBA code i.e. Sheet Change Event Code.
The following code will convert the Rand() formula entered in column A starting from Row2 to Values automatically.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…