Thanks for your suggestion,Roger.

I will send you what i am working on so it makes sense on your end, and see
what you can come up with.

Again, thanks for your help and suggestions!

S

"Roger Govier" wrote:

Hi Sharona

Still not sure I understand things fully from your explanation, but of
course it is quite obvious to you<bg

One thing to try maybe is to use MIN() within your formula somewhere.
=RLF/MIN(12,number_of_months)

If that doesn't help, you may email me direct with a copy of your file
and an explanation, and I will see if I can sort it out for you.
Remove NOSAPM from my address to send direct.

--
Regards

Roger Govier


"Sharona77" wrote in message
...
Thanks for your reply Roger-

the RLF is a calculation from another part of a different worksheet
involving salary, 3% increases, the appropriate fringe rates. It will
be
constant for the year grouping (calculations under year 2 cell
(example),
then 3%increase and diff. fringe rate for year4 cell, etc.) My
problems
a 1). I need the calculation to stop after it completes the
designated
year- the way I have it now, it calculates the diff over the whole
range
given (ie if F16 is 25 it calculates it for 13 months, not just 12). I
want
each cell to calculate up to the # of months in that year and then
stop at
that value, or give a 0 value only if the months are less than that
year (ie
if 25 months, the year 4 and 5 cells will give 0 values). I have a
cell for
2 year (example), 3yr, 4yr, and 5 yr. 2).I need the value to stay in
the cell
if it is applicable- right now it only is in the cell if it is in the
middle
of the range; if F16 were 25, it would come back with 0, instead of
the value
for months 12-24.

I know what I need to do, just not how to do it. Any help/ideas would
be
great!!!

Thanks!!

S

"Roger Govier" wrote:

Hi Sharona

I substituted the figure of 480 for your (really large formula).
With 13 in F16 it returns 40, with 14 it returns 80, with 15 it
returns
120 and so on, which is exactly what I would expect if the really
large
formula were returning a constant figure, as the divisor will be an
ever
increasing value between 1 and 12.
Is this the type of result you are looking for? If not, then
re-examine
this part.

Now, you need to turn to the really large formula bit, what is the
total
value being returned from here. Is this picking up the data from the
same range of months that you are dividing by?

--
Regards

Roger Govier


"Sharona77" wrote in message
...
I made the following formula:
=IF(AND(F1612,F16<25),(really large formula)/12*(F16-12),0)

F16 is the # of months. What I need to do is be able to calculate
only
for
the range of months listed, and if the # of months is higher, I
need
to keep
the calculation to a 12 month period only, not calculate higher
with
this set
of formulas. I will then have another line with the same basic
formula
calculating for the next year range, but only for 25-36 months, and
be
0 if
F16 is < 25 months.

Ideas? I can't figure out how to calculate only the months for the
ranges-
it keeps calculating more if F16 is greater than the range.

HELP!!