So I'm creating an amortization schedule in months, so 360 cells for a 30 year mortgage.
What I want to do:
Create an if statement that if the user inputs a term of say 15 years, then cells greater than 180 return a blank value.
So I'm creating an amortization schedule in months, so 360 cells for a 30 year mortgage.
What I want to do:
Create an if statement that if the user inputs a term of say 15 years, then cells greater than 180 return a blank value.
in cell B110 and so on if(B109>=180,"",....)
instead of 180 you can reference a cell say B2 that contains the length of the loan so =if(b109>=b$2,....) the $ sign is so when copied downwards it remains the same cell
Last edited by rcm; 04-25-2013 at 11:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks