Hi Tony,
could you please give an example it will help to clarify, (Future year, are
they columns by year, month ??)

"Tony" wrote:

I have a replacement reserve schedule that has the following information in
Columns €“ Current cost to replace, last year replaced, life of item (years),
Due for replacement, Year until next replaced, Future replacement cost and
each future year (now for the next 35 years). I have created a formula (IF /
THEN) that places the future replacement cost into to correct year. This
only works for the first year, but not any additional years, i.e. if the item
needs to be replaced every 4 years. Any thoughts on a formula I could use?