Forum Discussion
How to change the Number of Years to Number of Months
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.
It would help if you attached a copy of the workbook without sensitive info, or made it available via OneDrive, Google Drive or similar.
Thank you!
The file is empty so you can do what needs to be done.
The link to the file is https://www.dropbox.com/scl/fi/qqbtydp18b1n2ysaonnn6/TS0010197771.xlsx?rlkey=awqn837av6zgueqrxpxlpbd3s&dl=0
Here you go.
Thanks but what you did doesn't work for me. It does not calculate the monthly payment.
I need the input field to accept months not years and then calculate the months as (months/12) letting the rest of the fields do their job.
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.