Get instant live expert help on I need help with absolute cell references in excel
“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
Calculate the periodic interest rate in cell E3. I am only aloud to use absolute references.
Solved by D. H. in 24 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
how to find absolute value? I need to find absolute value with a formula I copied. I need to copy the formula into cell G4.
Solved by I. E. in 12 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
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.
Solved by M. A. in 26 mins