I am doing Monte Carlo simulations for N iterations which result in mean and median numbers, etc.
Once the MC is completed, I would like vba code to do additional sheet calculations until the value in a specified cell is approximately equal (within specified tolerance) to the mean and /or median.
I cannot just set the values as they are results of randomized returns but I want to display random spreadsheet results close to mean.
Does anyone know how I would do this?
Once the MC is completed, I would like vba code to do additional sheet calculations until the value in a specified cell is approximately equal (within specified tolerance) to the mean and /or median.
I cannot just set the values as they are results of randomized returns but I want to display random spreadsheet results close to mean.
Does anyone know how I would do this?