put:
=ROUNDDOWN(8800000/SUM(M4:M500),4)
in P4
--
Gary's Student


"Gary''s Student" wrote:

Perhaps...

Multiplying each number in N4:N500 by P4 and then adding them up is the same
thing as first adding all the N values and then doing a single mutiplication.
In either case you know that the answer should be 8,800,000.

For example, the the sum of N4:N500 was 8,796,481
then you would know that P4 must be 1.0004 by simple division.

I don't see why iteration is necessary??
--
Gary''s Student


"Ron M." wrote:

Thanks for trying, but your answer makes no sense at all.

Ron M.