apr to apy

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!
 
R

ryguy7272

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--
 
C

Carrie

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.
 

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

How do I combine 2 data sets using date? 2
Help needed with If & Today function 4
Countif OR Sumproduct OR Istext???? 2
table lookup 5
APR to APY 1
Dynamic sheet reference in Name formula 1
Cumulative sum, based on previous data 0
Summing a non continuous range 7

Top