Need help with iteration
Hi,
Gary's suggestion is perfect. All you want is a number in P4 such that P4
when multiplied by the total of M4:M500 will yield 8800000. So P4 should be
equal to 8800000/SUM(M4:M500).
In P4, use the formula =8800000/SUM(M4:M500)
Round the resulting number in P4 to the nearest ten-thousandth (since you
want to use increments of 0.0001, and 0.0001 is 1/10000)
Regards,
B. R. Ramachandran
"Ron M." wrote:
Thanks for trying, but your answer makes no sense at all.
Ron M.
|