I would like to use Excel to generate random numbers which:

a) are situated between values X and Y (so far no problem)

*AND*

b) yield a mean Z, which is different from the average of X and Y.

Could anyone help ?