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
fathermartin121
Favorite 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$.