apr to apy

  • Thread starter Thread starter Carrie
  • Start date Start date
C

Carrie

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!
 
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--
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate APR from ARY 2
APR to APY 1
drag formula down from columns that go acros 3
Countif OR Sumproduct OR Istext???? 2
Help needed with If & Today function 4
copy formula 3
Counting values in an array where value in one column is not null 5
Count values in array of data where no blanks in one column 4

Back
Top