Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Will
 
Posts: n/a
Default 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?
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for function or formula to calculate number that is revers Ken Excel Worksheet Functions 2 February 7th 05 11:18 AM
Need Formula or Function to calculate Margin (reverse of Percent a Ken Excel Worksheet Functions 1 February 7th 05 09:26 AM
Excel should have a quick and simple "change case" function like . NinaSvendsen Excel Worksheet Functions 1 January 28th 05 03:15 PM
Calculate change over time Gwen Excel Worksheet Functions 0 January 1st 05 05:52 PM
change function variable prompts?? thinkingfield Excel Worksheet Functions 1 November 8th 04 04:01 PM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"