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.
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.
I understand what you did and I thank you.
With that said, I downloaded the file to my computer and opened it with Excel 2010.
After entering different numbers, this is what I see.
How do I get it to function outside of Google Sheets and from an empty file on my computer?
I changed the formulas but I didn't bother to change all the prompts.