Start Calculation at a Specific Location Based on Dropdown Selection

**mrbmarsh** · 03-12-2015, 04:34 PM

I am working on a spreadsheet solution for a lease with a term of 60 months. I have a drop down list to select the month the initial lease payment is due. Further, I have created a table with 12 columns - one for each month. If I select, for example, "April," from the drop down list, I want the formula I have entered to start the calculation in the cell under the "April" column and continue to the "December" column (in the same row). Does anyone know how to do this?

Also in this same setup, I am calculating tax savings that only occur during the months of January, April, June, and September. How do I get Excel to recognize that tax savings only occur in the cell under the column for one of these months?

**FDibbins** · 03-12-2015, 04:40 PM

Hi, welcome to the forum

1st, I would suggest that instead of using a month name (like April), you use actual dates (1/1/15, 2/1/14 etc. We can then probably build an IF statement to give you what you want.

2nd, I suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.