Hi,
I've been struggling with trying to write a conditional formula to
automaticaly perform the following:

Problem
RL drives the intital placement of C1 in the correct year cloumn. I'm
currently using an =IF($A3<=E$1,$C3," ") to place the C1 value in the table
at the correct year and a blank if false. This works ok...but what I can't
seem to accomplish is...if the value is false then

....once the value C3 is entered in the table (E3 in the below example) I
need to count right from E3 the number of blank spaces defined by B3 + 1 and
then enter the value in D3 in the table (cell H3 in the example below). Then
using cell H3 as the new reference I need to count right from H3 the number
of blank spaces defined by B3 + 1 and then enter the value in D3 in the
table (cell K3 in the example below). This cycle then repeats for all future
years in the table (not shown in the example, the table actually extends to
2055)


Data Example

RL = REMAINING LIFE
EL = ESTIMATED LIFE
C1 = Cost of First Replacement
C2 = Cost of Future Replacements

A B C D E F G H
I J K
1 1 2 3 4
5 6 7
2 RL EL C1 C2 2009 2010 2011 2012 2013
2014 2015
3 1 2 $50 $100 $50 $100
$100


Thanks in advance for any help or thoughts

I'm at work so just a quick comment - use "" not " " to indicate a blank.


--
Thanks,
Shane Devenshire


"Stressless" wrote:

Hi,
I've been struggling with trying to write a conditional formula to
automaticaly perform the following:

Problem
RL drives the intital placement of C1 in the correct year cloumn. I'm
currently using an =IF($A3<=E$1,$C3," ") to place the C1 value in the table
at the correct year and a blank if false. This works ok...but what I can't
seem to accomplish is...if the value is false then

...once the value C3 is entered in the table (E3 in the below example) I
need to count right from E3 the number of blank spaces defined by B3 + 1 and
then enter the value in D3 in the table (cell H3 in the example below). Then
using cell H3 as the new reference I need to count right from H3 the number
of blank spaces defined by B3 + 1 and then enter the value in D3 in the
table (cell K3 in the example below). This cycle then repeats for all future
years in the table (not shown in the example, the table actually extends to
2055)


Data Example

RL = REMAINING LIFE
EL = ESTIMATED LIFE
C1 = Cost of First Replacement
C2 = Cost of Future Replacements

A B C D E F G H
I J K
1 1 2 3 4
5 6 7
2 RL EL C1 C2 2009 2010 2011 2012 2013
2014 2015
3 1 2 $50 $100 $50 $100
$100


Thanks in advance for any help or thoughts