I'm working on a schedule that would output a number based on 1) which quarter amortization begins and 2) the number of months in the amortization period. Here's an excerpt of my data and what I have so far:
A1 = quarter drop down
A2= month drop down
27 mo 30 mo 33 mo
Q1 222 245 270
Q2 230 255 278
Q3 222 252 277
Q4 223 245 275
example (for 27 mo): =if(A1=A5,B5,if(A1=A6,B6,if(A1=A7,B7,if(A1=A8,B8))))
(for 30 mo): =if(A1=A5,C5,if(A1=A6,C6,if(A1=A7,C7,if(A1=A8,C8))))
The problem is that the formula only takes into account the quarter selection; a different formula needs to be used depending on the armotization period, so the schedule cannot easily be updated. I need it to take into account the amortization period (i.e. 27, 30, 33) without having to select a different formula (be able to select a different amortization period and have the schedule automatically update). So we need an "if and if" statement. (If A1=Q1 and B1=27, then 222 for instance). Is this possible? Any ideas?
Bookmarks