I have a run of numbers each run contains about 10 or so numbers), all with
eight decimal places. The total of this run must equal 1.00000000. We have
loads of these to review. Is there a way to create a formula that would look
at the sum and if it does not equal 1.00000000, then it would go up into the
run of numbers and randomly adjust the numbers so that the displayed run
equals 1.00000000

We know we can sum and then manually adjust - that is just not feasible.