Add-in Functions, List of Analysis Functions Part One

note

The Add-in functions are supplied by the UNO com.sun.star.sheet.addin.Analysis service.


Доступ к этой команде

Вставить функцию - Тип Надстройка


DELTA

Возвращает значение TRUE (1), если оба числа, указанные в качестве аргументов, равны. В противном случае возвращает значение FALSE (0).

Синтаксис

DELTA(Number1 [; Number2])

Пример

=DELTA(1;2) возвращает 0.

БЕССЕЛЬ.I

Calculates the modified Bessel function of the first kind In(x).

Синтаксис

BESSELI(X; N)

X: значение для расчёта функции.

N is a positive integer (N >= 0) representing the order of the Bessel function In(x)

Пример

=BESSELI(3.45, 4), returns 0.651416873060081

=BESSELI(3.45, 4.333), returns 0.651416873060081, same as above because the fractional part of N is ignored.

=BESSELI(-1, 3), returns -0.022168424924332

БЕССЕЛЬ.J

Calculates the Bessel function of the first kind Jn(x) (cylinder function).

Синтаксис

BESSELJ(X; N)

X: значение для расчёта функции.

N is a positive integer (N >= 0) representing the order of the Bessel function Jn(x)

Пример

=BESSELJ(3.45, 4), returns 0.196772639864984

=BESSELJ(3.45, 4.333), returns 0.196772639864984, same as above because the fractional part of N is ignored.

=BESSELJ(-1, 3), returns -0.019563353982668

БЕССЕЛЬ.K

Calculates the modified Bessel function of the second kind Kn(x).

Синтаксис

BESSELK(X; N)

X is the strictly positive value (X > 0) on which the function will be calculated.

N is a positive integer (N >= 0) representing the order of the Bessel function Kn(x)

Пример

=BESSELK(3.45, 4), returns 0.144803466373734

=BESSELK(3.45, 4.333), returns 0.144803466373734, same as above because the fractional part of N is ignored.

=BESSELK(0, 3), returns Err:502 – invalid argument (X=0)

БЕССЕЛЬ.Y

Calculates the Bessel function of the second kind Yn(x).

Синтаксис

BESSELY(X; N)

X is the strictly positive value (X > 0) on which the function will be calculated.

N is a positive integer (N >= 0) representing the order of the Bessel function Yn(x)

Пример

=BESSELY(3.45, 4), returns -0.679848116844476

=BESSELY(3.45, 4.333), returns -0.679848116844476, same as above because the fractional part of N is ignored.

=BESSELY(0, 3), returns Err:502 – invalid argument (X=0)

ДВ.В.ВОСЬМ

The result is the string representing the number in octal form for the binary (base-2) number string entered.

Синтаксис

BIN2OCT(Number [; Places])

Number is a string representing a binary (base-2) number. It can have a maximum of 10 places (bits). The most significant bit is the sign bit. Negative numbers are entered as two's complement.

Разряды: количество выводимых разрядов.

Пример

=BIN2OCT("1100100";4) returns "0144".

ДВ.В.ДЕС

The result is the number for the binary (base-2) number string entered.

Синтаксис

BIN2DEC(Число)

Number is a string representing a binary (base-2) number. It can have a maximum of 10 places (bits). The most significant bit is the sign bit. Negative numbers are entered as two's complement.

Пример

=BIN2DEC("1100100") returns 100.

ДВ.В.ШЕСТН

The result is the string representing the number in hexadecimal form for the binary (base-2) number string entered.

Синтаксис

BIN2HEX(Number [; Places])

Number is a string representing a binary (base-2) number. It can have a maximum of 10 places (bits). The most significant bit is the sign bit. Negative numbers are entered as two's complement.

Places means the number of places to be output.

Пример

=BIN2HEX("1100100";6) returns "000064".

ДЕС.В.ВОСЬМ

The result is the string representing the number in octal form for the number entered.

Синтаксис

DEC2OCT(Number [; Places])

Number is a number. If Number is negative, the function returns an octal number string with 10 characters (30 bits). The most significant bit is the sign bit, the other 29 bits return the value.

Разряды: количество выводимых разрядов.

Пример

=DEC2OCT(100;4) returns "0144".

ДЕС.В.ДВ

The result is the string representing the number in binary (base-2) form for the number entered.

Синтаксис

DEC2BIN(Number [; Places])

Number is a number between -512 and 511. If Number is negative, the function returns a binary number string with 10 characters. The most significant bit is the sign bit, the other 9 bits return the value.

Разряды: количество выводимых разрядов.

Пример

=DEC2BIN(100;8) returns "01100100".

ДЕС.В.ШЕСТН

The result is the string representing the number in hexadecimal form for the number entered.

Синтаксис

DEC2HEX(Number [; Places])

Number is a number. If Number is negative, the function returns a hexadecimal number string with 10 characters (40 bits). The most significant bit is the sign bit, the other 39 bits return the value.

Разряды: количество выводимых разрядов.

Пример

=DEC2HEX(100;4) returns "0064".

ДФОШ

Возвращает дополнительные значения гауссова интеграла ошибок от x до бесконечности.

Синтаксис

ERFC(LowerLimit)

LowerLimit: нижний предел интеграла.

Пример

=ERFC(1) возвращает 0,157299.

ДФОШ.ТОЧН

Returns complementary values of the Gaussian error integral between x and infinity.

Синтаксис

ДФОШ.ТОЧН(НижнийПредел)

LowerLimit: нижний предел интеграла.

Пример

=ERFC.PRECISE(1) возвращает 0,157299.

Техническая информация

tip

Эта функция доступна начиная с LibreOffice 4.3.


This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.ERFC.PRECISE

ПОРОГ

Возвращает значение 1, если число больше либо равно порогу.

Синтаксис

GESTEP(Number [; Step])

Пример

=GESTEP(5;1) возвращает 1.

ФОШ

Возвращает значения гауссова интеграла ошибок.

Синтаксис

ERF(LowerLimit [; UpperLimit])

LowerLimit: нижний предел интеграла.

UpperLimit is optional. It is the upper limit of the integral. If this value is missing, the calculation takes place between 0 and the lower limit.

Пример

=ERF(0;1) возвращает 0,842701.

ФОШ.ТОЧН

Возвращает значения гауссова интеграла ошибок от 0 до бесконечности.

Синтаксис

ФОШ.ТОЧН(НижнийПредел)

LowerLimit is the limit of the integral. The calculation takes place between 0 and this limit.

Пример

=ERF.PRECISE(1) возвращает 0.842701.

Техническая информация

tip

Эта функция доступна начиная с LibreOffice 4.3.


This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.ERF.PRECISE

ШЕСТН.В.ВОСЬМ

The result is the string representing the number in octal form for the hexadecimal number string entered.

Синтаксис

HEX2OCT(Number [; Places])

Number is a string that represents a hexadecimal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.

Разряды: количество выводимых разрядов.

Пример

=HEX2OCT("6a";4) returns "0152".

ШЕСТН.В.ДВ

The result is the string representing the number in binary (base-2) form for the hexadecimal number string entered.

Синтаксис

HEX2BIN(Number [; Places])

Number is a string that represents a hexadecimal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.

Разряды: количество выводимых разрядов.

Пример

=HEX2BIN("6a";8) returns "01101010".

ШЕСТН.В.ДЕС

The result is the number for the hexadecimal number string entered.

Синтаксис

HEX2DEC(Число)

Number is a string that represents a hexadecimal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.

Пример

=HEX2DEC("6a") returns 106.