|
Читайте также: |
This dialog box appears when you click the Insert Function button. It can assist you in defining your function.
Circular reference
Situation when some parameter in the formula refers to the formula itself
For example, in cell C5 the following formula is entered:
VLOOKUP(C5, F2:G15, 2, TRUE)
The address C5 refers to the formula itself.
In this case it is a wrong way of writing the formula.
In some cases circular references may be used
for creating recursive (recurrent) functions.
Дата добавления: 2015-09-01; просмотров: 34 | Нарушение авторских прав
| <== предыдущая страница | | | следующая страница ==> |
| VLOOKUP Function | | | II. Body (background information) |