help with my formula please


Thanks for the Solution mark, but I discovered a mistake in my approach. The last of the "random" numbers must be constrained to be the difference between the sum of the preceeding random numbers and the total. My revised, hopefully correct, version is this:
The figure in cell A6, 63 in the example, is the constrained one.
The formula for the A6 is:
=A7SUM(A$2:A5)
Sorry about the false start.
Jerry

Like (0)


THANKS JERRY
Jerrold Green1 wrote:
Thanks for the Solution mark, but I discovered a mistake in my approach. The last of the "random" numbers must be constrained to be the difference between the sum of the preceeding random numbers and the total. My revised, hopefully correct, version is this:
The figure in cell A6, 63 in the example, is the constrained one.
The formula for the A6 is:
=A7SUM(A$2:A5)
Sorry about the false start.
Jerry

Like (0)
