SpreadCE Help

Проверка свойств и значений functions

[ ] indicates optional parameters

Проверка свойств и значений functions

ЕЛОГИЧ(значение)

Returns ИСТИНА if the value is a logical value, otherwise ЛОЖЬ.

значение

The expression whose result you want to check.

ЕНД(значение)

Returns ИСТИНА if the value is the error #Н/Д, otherwise ЛОЖЬ.

значение

The expression whose result you want to check.

ЕНЕТЕКСТ(значение)

Returns ИСТИНА if the value is not a string, otherwise ЛОЖЬ.

значение

The expression whose result you want to check.

ЕНЕЧЁТ(число)

Returns ИСТИНА if the number is odd, otherwise ЛОЖЬ.

число

The number you want to check.

ЕОШ(значение)

Returns ИСТИНА if the value is an error other than #Н/Д, otherwise ЛОЖЬ.

значение

The expression whose result you want to check.

ЕОШИБКА(значение)

Returns ИСТИНА if the value is an error, otherwise ЛОЖЬ.

значение

The expression whose result you want to check.

ЕПУСТО(значение)

Returns ИСТИНА if the value is a reference to an empty cell, otherwise ЛОЖЬ.

значение

The cell whose value you want to check.

ЕССЫЛКА(значение)

Returns ИСТИНА if the value is a reference, otherwise ЛОЖЬ.

значение

The expression whose result you want to check.

ЕТЕКСТ(значение)

Returns ИСТИНА if the value is a string, otherwise ЛОЖЬ.

значение

The expression whose result you want to check.

ЕЧЁТН(число)

Returns ИСТИНА if the number is even, otherwise ЛОЖЬ.

число

The number you want to check.

ЕЧИСЛО(значение)

Returns ИСТИНА if the value is a number, otherwise ЛОЖЬ.

значение

The expression whose result you want to check.

ИНФОРМ(тип_информации)

Returns information about the current spreadsheet.

тип_информации

The type of information you want returned. The possible values are:

"КАТАЛОГ"	The path of the current file
"ДОСТУПНАЯПАМЯТЬ"	The number of bytes of memory available
"ИСПОЛЬЗУЕМАЯПАМЯТЬ"	The number of bytes of memory used
"ЧИСЛОФАЙЛОВ"	The number of spreadsheet files that are open
"ИСТОЧНИК"	A string containing the address of the cell in the top-left corner of the scrollable region
"ВЕРСИЯОС"	The operating system version number
"ПЕРЕВЫЧИСЛИТЬ"	A string containing "Automatic" or "Manual", depending on the recalculation mode
"ВЕРСИЯ"	The release version with which this program is compatible
"СИСТЕМА"	The operating system type
"ПАМЯТЬВСЕГО"	The total number of bytes of memory

НД()

Returns the error value #Н/Д.

СЧИТАТЬПУСТОТЫ(диапазон)

Returns the number of blank cells in a range.

диапазон

The reference of the cells you want to check.

ТИП(значение)

Returns a number corresponding to the type of the value.

значение

The value, or cell containing the value, that you want to check.

The returned values are:

число	1
строка	2
флаг	4
ошибка	16
массив	64

ТИП.ОШИБКИ(значение_ошибки)

Returns a number corresponding to the type of the error.

значение_ошибки

The error value, or cell containing the error value, that you want to check.

The returned values are:

#ПУСТО!	1
#ДЕЛ/0!	2
#ЗНАЧ!	3
#ССЫЛКА!	4
#ИМЯ?	5
#ЧИСЛО!	6
#Н/Д	7
other	#Н/Д

Ч(значение)

Returns a number corresponding to the input value, or 0 if the input value is a string. You should not need to use this function, as values are automatically converted where necessary when they are used in formulas.

значение

The value you want as a number.

ЯЧЕЙКА(тип_информации, [ссылка])

Returns information about a worksheet cell.

тип_информации

The type of information you want returned. The possible values are:

"АДРЕС"	A string containing the cell reference
"СТОЛБЕЦ"	The column number of the cell
"ЦВЕТ"	1 if the cell is formatted in color for negative values, otherwise 0 (not currently implemented)
"СОДЕРЖИМОЕ"	The result of the formula in the cell, or 0 if the cell is empty
"ИМЯФАЙЛА"	The path, filename and sheet name of the cell
"ФОРМАТ"	The number format that has been applied to the cell
"СКОБКИ"	1 if the cell is formatted in parentheses for positive values, otherwise 0 (not currently implemented)
"ПРЕФИКС"	The text alignment that has been applied to the cell (not currently implemented)
"ЗАЩИТА"	1 if the cell is locked, otherwise 0
"СТРОКА"	The row number of the cell
"ТИП"	A string representing the type of the cell result: "b" for blank, "l" for label (string), otherwise "v"
"ШИРИНА"	The cell width in characters

ссылка

The cell about which you want information. If this parameter is omitted it defaults to the cell containing the formula.