Don't know about a simple formula, my understanding of Monte Carlo
simulations is that it is not simple, but the a search on Google using
'monte carlo excel vba' threw up 6,000+ entries. Take a look
http://tinyurl.com/axzsg

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MonteUser" wrote in message
...
I'm looking for a simple macro for Monte carlo sim? I'd apprectiate any
help.

many thanks