Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
having some excel trouble?
10. In cell B18, enter a formula to calculate the amount of money loaned to Ghana in 2013 that SWM can expect will be repaid. In the formula, use a relative reference to the loan amount in cell B12 and an absolute reference to the “Repayment rate to date” value in cell K1. Copy the formula in cell B18 to the range C18:M18. B12 is 3570 and K1 is 96% whats the formula going to look like
1 Answer
- fathermartin121Lv 610 years agoFavorite Answer
You have copied a question, but not asked a question of your own. My guess is that you do not understand relative and absolute references.
When coping formula down a column, it will change the cell reference to the related cells next to the formula, rather than the original cells in the first row.
If you want the formula to relate to a fixed cell, such as K1, which contains the "Repayment rate to date", then you need to highlight K1 in the formula and press the function key, F4. This will change it to the Absolute Reference: K$1$.
