|
Читайте также: |
To understand why this may be so, consider what the above formula is really saying.
To Excel, B4/F4 actually translates as “when I’m sitting in cell B5, divide the number that is one row above me by the number that is four columns to my right and one row up.”
In other words, the formula as written tells Excel to make a calculation relative to the cursor’s current position. Remember: the cursor always tells to Excel its current location (note B5 in the name box above).
What you need to do for the formula to copy correctly is to tell Excel always to use the $4,100 (i.e., the contents of cell F4) -- no matter where you copy the formula.
To do this, you need to make the reference to cell F4 an absolute reference rather than a relative reference. Use Page Down to see how to do this.
Дата добавления: 2015-09-01; просмотров: 33 | Нарушение авторских прав
| <== предыдущая страница | | | следующая страница ==> |
| Absolute vs. Relative references | | | Use the F4 key for absolute references |