Here are some problems that our users have asked and received explanations on
Need help with how to use if function in excel 2016 that requires absolute referencing
Solved by D. J. in 29 mins
Insert the PMT function in cell J5 to calculate the first client's monthly payment, using appropriate relative and using excel absolute value function. Copy the formula down the column.
Solved by I. E. in 16 mins
On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references.
Solved by S. S. in 30 mins
how do you absolute assign a row on an excel spreadsheet? Please advise. Thanks Janice
Solved by D. F. in 16 mins
Enter a function in cell E12, based on the payment and loan details, that calculates the amount of principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.