|
Читайте также: |
The screen above shows the formula corrected so that it will give the desired results after it is copied.
To convert a relative reference to an absolute reference while building a formula, press the F4 key immediately after clicking on the desired location with the cursor (in this case, the immediately after selecting the cell that has $4,100 in it).
The formula changes to show a $ in front of both the column and the row for that location.
You will notice that if you continue to press the F4 key, the command toggles to set the column, then the row, then both as absolute references.
Trivia: Excel uses the $ to indicate absolute references because in the early days of spreadsheets PC keyboards had so few keys that software designers had to find multiple uses for each symbol. The company that first did this now out of business, but the $ stuck.
Дата добавления: 2015-09-01; просмотров: 38 | Нарушение авторских прав
| <== предыдущая страница | | | следующая страница ==> |
| Formula references | | | Using Functions in Excel |