Get instant live expert help on I need help with relative reference 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
In cell G5, reference the payoff date of the loan in B70. Be sure to use a relative reference to the cell containing the date.
Solved by V. U. in 26 mins
How can I reference cell data relative to the row from which the data is being pulled?
Solved by K. B. in 16 mins
In cell C11, insert a relative reference to the loan amount in C4.
In cell D11, insert an absolute reference to the monthly payment amount in G4.
In cell G11, use relative references to add the values in cells C11 and F11.
Select the range D11:G11, and then use the fill handle to copy the functions to row 12.
In cell C12, insert a relative reference to the ending balance in cell G11.
Select the range A11:B12, and then use the fill handle to complete the columns through row 70. (Note the cells to select here - it is just A11:B12 - not the whole range.)
Solved by O. J. in 24 mins
How to fetch multiple relative position (horizontally) of a Reference cell value of Sheet2 into Sheet1; and as the reference cell value changes thus changes the formula.
Solved by X. W. in 19 mins
In cell A11, enter 1 as the first payment number and in cell B11, enter 9/1/2017 as the first payment date.
In cell C11, insert a relative reference to the loan amount in C4.
In cell D11, insert an absolute reference to the monthly payment amount in G4.
In cell G11, use relative references to add the values in cells C11 and F11.
Select the range D11:G11, and then use the fill handle to copy the functions to row 12.
Solved by O. C. in 28 mins