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?