Hi, I am trying to write a nested conditional IF formula where a loan term may be 12 month, 12.5 (etc), or 13 months (etc), and then calculate the cash flow (payment), and so I need to use a conditional logic formula to calculate the 12th month payment, and (if there is a fraction) a 12.5th (stub 13th) month payment, or full 13 month payment etc. Loan term is variable (depending upon user's input assumption) and so i need to be able to figure cash on that variable term.
Solved by D. E. in 24 mins