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

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

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

Hey, I'm trying to calculate the loan amount and the monthly payment together of a set of data where I have the years, Purchase Price, Down Payment and the apr.

Solved by C. D. in 23 mins

Can you format cells to read Jan, Feb, Mar, Apr by just putting one date in?

Solved by I. J. in 24 mins