Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 68
Default apr to apy

hi,

i wasn't trying to get that specific. only if a bank states that it gives a
5.50 APR,
I just want to put that into a field, and have it convert to APY.

other banks gives only APY's. I want to plug that into a field, and have it
give me the APR.



"ryguy7272" wrote:

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!

 
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



All times are GMT +1. The time now is 10:39 AM.

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

About Us

"It's about Microsoft Excel"