Setting a cell with a value as a reference for another function
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 |
Setting a cell with a value as a reference for another function
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 |
All times are GMT +1. The time now is 12:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com