does it have to be exactly 4.2 or do you want the numbers drawn from a
population that has an average of 4.2. What is the distribution you are
sampling from: Uniform, Normal, Triangular, Something else.

--
Regards,
Tom Ogilvy

"Steve C" wrote in message
...
I would like to have Excel generate a range of random integers in cells A1
to
A40 and have the final average of that entire range = 4.2 (or any numeric
value I stipulate). I also want to place a constraint on each cell; that
it
can only contain an integer and a minimum/maximum range of say, -6 to +14.
Is this possible? Thanks!

Steve C