Hello all!

I am still struggling to create a simulation I was wondering if anyone could point me in the right direction please?

I have a list of staff and their voluntary redundant salaries and compulsory redundant salaries

I have the figure of the number of job losses

I am predicting that 60% of job losses will be staff taking voluntary redundancy and the other 40% of job losses will be compulsory redundancies

Therefore I want to run 1000 trials of choosing these 60% and 40% to see the distribution of the total cost of redundancies.

Any ideas of how i can do this in excel?

Thanks you!