I am looking for a formula that will develop a factor based on months.

Example:

at 12 months the developmental factor is 1.724
at 24 months the developmental factors is 1.347

I need a formula that would give me the developmental factor at 19 months

Any help is much appreciated...

Is there a linear relationship between the two stated factors, or does
the factor last for 12 months and then change? What is the factor
below 12 months? Will you enter 19 (months) directly, or derive it
from a start and end date?

Please give more details.

Pete

On Apr 17, 4:00 pm, walkerT wrote:
I am looking for a formula that will develop a factor based on months.

Example:

at 12 months the developmental factor is 1.724
at 24 months the developmental factors is 1.347

I need a formula that would give me the developmental factor at 19 months

Any help is much appreciated...

Pete, the developmental factor last for 12 months and then changes at 24...So
I am looking to develop it at 19 months

"Pete_UK" wrote:

Is there a linear relationship between the two stated factors, or does
the factor last for 12 months and then change? What is the factor
below 12 months? Will you enter 19 (months) directly, or derive it
from a start and end date?

Please give more details.

Pete

On Apr 17, 4:00 pm, walkerT wrote:
I am looking for a formula that will develop a factor based on months.

Example:

at 12 months the developmental factor is 1.724
at 24 months the developmental factors is 1.347

I need a formula that would give me the developmental factor at 19 months

Any help is much appreciated...

You didn't answer my other questions, so assuming you enter 19 into
A1, you can use this formula to derive the factor:

=IF(A1<12,0,IF(A1<24,1.724,1.347))

This gives you a factor of 0 for less than 12 months - change as
appropriate.

Hope this helps.

Pete

On Apr 17, 4:20 pm, walkerT wrote:
Pete, the developmental factor last for 12 months and then changes at 24...So
I am looking to develop it at 19 months



"Pete_UK" wrote:
Is there a linear relationship between the two stated factors, or does
the factor last for 12 months and then change? What is the factor
below 12 months? Will you enter 19 (months) directly, or derive it
from a start and end date?

Please give more details.

Pete

On Apr 17, 4:00 pm, walkerT wrote:
I am looking for a formula that will develop a factor based on months.

Example:

at 12 months the developmental factor is 1.724
at 24 months the developmental factors is 1.347

I need a formula that would give me the developmental factor at 19 months

Any help is much appreciated...- Hide quoted text -

- Show quoted text -