Forum Discussion

Harvey_Arkawy's avatar
Harvey_Arkawy
Copper Contributor
Sep 19, 2023
Solved

How to change the Number of Years to Number of Months

I have TS0010197771.xlsx with Excel 2010. The Amortization is based on the number of years the loan is to be paid off.  I have a loan that is 75 months; 6 years and 3 months. How do I change the inp...
  • HansVogelaar's avatar
    HansVogelaar
    Sep 20, 2023

    Harvey_Arkawy 

    In the attached version, I cleaned up the terminology as best I could and removed the cell where you originally could enter the number of payments per year.

Resources