Get instant live expert help on I need help with absolute and relative
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Insert the PMT function in cell J5 to calculate the first clients monthly payment, using appropriate relative and absolute cell references. Copy the formula down the column.
Solved by V. B. in 19 mins
Enter a function in cell D12, based on the payment and loan details, that calculates the amount of interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Solved by G. L. in 22 mins
Enter a function in cell G12, based on the payment and loan details, that calculates the amount of cumulative interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Solved by B. J. in 13 mins
Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting.
Solved by D. Y. in 21 mins
Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the Value in cell E11 to lookup the appropriate cost on the "Insurance Cost" reference table (range K11:L18). Make sure to use relative and absolute references appropriately
Solved by I. D. in 27 mins