“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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