Читайте также: |
|
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 |