I am trying to create a worksheet where I can calculate growth based on the launch year. Currently I have everything entered with the launch of 2012, but I would like everything to calculate automatically when the launch year is changed (B6). For example, if 2013 is typed as the launch year, all the numbers from F6 to J6 would be the same, except they would now shift over and start and G6. I have tried using nested IF statements, but it isn't calculating correctly. Here is what I have so far in cells D6 and E6: =IF($B$6=D5,$A$6*B3,IF($B$6<D5,C6*C3,0)), but I know it will run into trouble as soon as I move the formula into 2012. Is there a way to fix this IF statement, or do I need to create a macro. Thanks for your help.
Bookmarks