formula

W

walkerT

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...
 
P

Pete_UK

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
 
W

walkerT

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

Pete_UK

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
 
Top