 # Get instant live expert help on how to calculate apr in excel “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

How do you enter this problem in excel? The answer is \$250.00, I cannot get the answer PMT=P(APR/n)/1-(1+APR/n)-nY 25000*(0.12/12)/1-(1+0.12/12)-12*25
Solved by K. S. in 24 mins
I have a problem with the month# desired entered in cell C1. Dates are in Cells C3-Z3 (i.e. Jan-2016 to Dec 2017). Product1 name is in cell B5. Product2 name is in cell B6. Data1 amounts are in C5 to Z5. Data2 amounts are in C6 to Z6. What formula would I need to add in cell AB5? Given the below specs: Col AB5 needs to calculate the rolling 12 months based on cell C1. So if C1=3 (i.e. Mar 2017), it should calculate amounts in F5 through Q5 (i.e. Apr 2016 through Mar 2017). If C1=4 (i.e. Apr 2017), it should dynamically calculate amounts in G5 through R5 (i.e. May 2016 through Apr 2017). Any help will be greatly appreciated. Thank you!
Solved by D. Y. in 21 mins
How to calculate time in excel with date added?
Solved by S. W. in 16 mins
calculate the loan amount, the number of payment periods, and the monthly interest rate: Info given: complex cost down payment # of pmts per year years apr 1st payment date
Solved by K. L. in 29 mins
A1=ABC B1=01-Jan-2018 A1=ABC B1=15-Feb-2018 A1=ABC B1=06-Apr-2018 how to find gap in days of first issue and last issue
Solved by T. S. in 16 mins