Студопедия
Случайная страница | ТОМ-1 | ТОМ-2 | ТОМ-3
АрхитектураБиологияГеографияДругоеИностранные языки
ИнформатикаИсторияКультураЛитератураМатематика
МедицинаМеханикаОбразованиеОхрана трудаПедагогика
ПолитикаПравоПрограммированиеПсихологияРелигия
СоциологияСпортСтроительствоФизикаФилософия
ФинансыХимияЭкологияЭкономикаЭлектроника

Absolute vs. Relative references

Use the F4 key for absolute references | Using Functions in Excel | VLOOKUP Function | Examine the Insert Function dialog box |


Читайте также:
  1. Formula references
  2. List of References
  3. References
  4. Translator's Notes and References
  5. Use the F4 key for absolute references

Copying formulas does not always work

 
 

 

 


This formula calculates first-quarter sales as a percentage of total year sales.

Not surprisingly, it divides the number in cell B4 ($1,000) by the number in cell F4 ($4,100).

However, when you pull the extension handle to copy the formula for Quarters 2,3, and 4, you don’t get the results you want. Press the Page Down key several times to see what happens.

#DIV/0! means Excel is trying to tell you that you have asked it to divide by 0 -- an operation for which there is no answer. Why is this happening?

Дата добавления: 2015-09-01; просмотров: 44 | Нарушение авторских прав

<== предыдущая страница | следующая страница ==>
Why to Study it?| Formula references
mybiblioteka.su - 2015-2024 год. (0.005 сек.)