Thread: apr to apy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default apr to apy

Since you didn't give any specific details of your scenario, just look in the
help menu for the following...adapt to suit your needs...
RATE(nper,pmt,pv,fv,type,guess)

FV(rate,nper,pmt,pv,type)

Regards,
Ryan--

--
RyGuy


"Carrie" wrote:

Hi,

I was looking for two formulas. One if I have an APR, to be able to insert
that and get the APY. Same thing in reverse...if i have an APY to input it
to get an APR.

thanks!

 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.