|
Читайте также: |
February 16th, 2005
A basic function that retrieves information on a specified cell - in particular the formatting.
The syntax is CELL(INFO_TYPE; REFERENCE)
Info_type is the character string that specifies the type of information. The character string is always in English. Upper or lower case is optional.
Reference is the position of the cell to be examined. If Reference is a range, the cell moves to the top left of the range. If Reference is missing, OpenOffice.org Calc uses the position of the cell in which this formula is located. Microsoft Excel uses the reference of the cell in which the cursor is positioned.
The examples below show the different type of information that can be obtained for a cell
Posted in Function Tips | No Comments»
Дата добавления: 2015-08-03; просмотров: 61 | Нарушение авторских прав
| <== предыдущая страница | | | следующая страница ==> |
| Filling a Cell Range with a Series | | | Copying Formulas while preserving references |