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

Need help for an excel problem regarding payment calculations. Also need a double check for my work. Specifically need help In PPMT and IPMT

Solved by B. D. in 12 mins

=-PPMT(B4,A19,20,B4) IS NOT WORKING AS IT DID IN THE OTHER 14 CELLS

Solved by S. A. in 18 mins

Using cell references, create a PMT formula in cell D8 to calculate the monthly loan from NewVentures CapitalInc. Bote: the PMT function uses the same arguments as the PPMT function with the exception that there is no PER criterion. Remeber to divide the rate by 12 and multiply the NPER by 12 to use the monthly units. Using cell refrences create PPMT formulas to find theprincipal portion of the loan payment for the first loan payment in cell D10 and the last loan payment in cell D11. In cell D13, create a formula to calculate the total cost of the loan by multiplying the monthly loan payment times the authorization period in years times 12.

Solved by D. J. in 13 mins

I need help on how to use indirect function along with sumifs function in excel.

Solved by Z. W. in 15 mins

In EXCEL 2016 HOUR Function in SQL fails with "Hour is not a recognized function

Solved by M. J. in 15 mins