ExcelBanter - Can you change the PMT function tio calculate off of 365 days?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can you change the PMT function tio calculate off of 365 days? (https://www.excelbanter.com/excel-worksheet-functions/18331-can-you-change-pmt-function-tio-calculate-off-365-days.html)

Will

Can you change the PMT function tio calculate off of 365 days?

Can you change the PMT function tio calculate off of 365 days instead of 360?

N Harkawat

PMT is NOT dependent on 365 or 360 days
It solely dependent on your rate used.

Just adjust the rate to suit your needs
For instance if the rate is 10% for 365 days then for 360 days =
10.0000190241598%

"Will" wrote in message
...
Can you change the PMT function tio calculate off of 365 days instead of
360?

All times are GMT +1. The time now is 03:13 PM.