I think I might benefit from a clearer definition of the problem. Can you
express the function required in a more generic form, the examples raises
too many what if questions for me. Sorry

--
Cheers
Nigel



"NWO" wrote in message
...
Hello all.

Here is my business problem for which I am seeking a solution:

Desired outcome - generate a cycle time based on varible number of input
values marked agianst a set vaue. Example, I have a fixed value of 1,000,
and a string of consecutive monthly receipt values (from nearest month to
farthest month), say 300, 200, 300, 450. I need a solution to determine
how
many times of these values go into 1,000, and the last value expressed as
a
decimal, if applicable. So, using the above vlaue would generate a cyckle
time of 3.4444. That is, 300 =1 because 300 < 100, 200 = 2, because
300+200
< 1000, 300 = 3 because 300+200+300 < 1,000., and the difference between
1,000 and 800 divided by 450 = .4444. I have tried countif, sumif, arrays,
and I just can;'t seem to find a solution other than manually performimng
the
calucation every time.

Any ideas to create a specialized formula or function to handle this task?

Thank you.

Mark :)