Add-in Functions, List of Analysis Functions Part One
The Add-in functions are supplied by the UNO com.sun.star.sheet.addin.Analysis service.
БЕССЕЛЬ.I
Calculates the modified Bessel function of the first kind In(x).
БЕССЕЛЬ.I(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).
БЕССЕЛЬ.J(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).
БЕССЕЛЬ.K(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).
БЕССЕЛЬ.Y(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.
Разряды: количество выводимых разрядов.
=ДВ.В.ВОСЬМ("1100100"; 4) возвращает значение «0144».
ДВ.В.ДЕС
The result is the number for the binary (base-2) number string entered.
ДВ.В.ДЕС(Число)
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.
=ДВ.В.ДЕС("1100100") возвращает значение 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.
=ДВ.В.ШЕСТН("1100100"; 6) возвращает значение «000064».
ДЕЛЬТА
Возвращает значение ИСТИНА (1), если оба числа, указанные в качестве аргументов, равны. В противном случае возвращает значение ЛОЖЬ (0).
DELTA(Number1 [; Number2])
=ДЕЛЬТА(1; 2) возвращает 0.
ДЕС.В.ВОСЬМ
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 до бесконечности.
ДФОШ(НижнийПредел)
LowerLimit: нижний предел интеграла.
=ДФОШ(1) возвращает 0,157299.
ДФОШ.ТОЧН
Returns complementary values of the Gaussian error integral between x and infinity.
ДФОШ.ТОЧН(НижнийПредел)
LowerLimit: нижний предел интеграла.
=ДФОШ.ТОЧН(1) возвращает 0,157299.
COM.MICROSOFT.ERFC.PRECISE
ПОРОГ
Возвращает значение 1, если число больше либо равно порогу.
GESTEP(Number [; Step])
=ПОРОГ(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.
=ФОШ(0; 1) возвращает 0,842701.
ФОШ.ТОЧН
Возвращает значения гауссова интеграла ошибок от 0 до бесконечности.
ФОШ.ТОЧН(НижнийПредел)
LowerLimit is the limit of the integral. The calculation takes place between 0 and this limit.
=ФОШ.ТОЧН(1) возвращает 0,842701.
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.
Разряды: количество выводимых разрядов.
=ШЕСТН.В.ВОСЬМ("6a";4) возвращает значение «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.
Разряды: количество выводимых разрядов.
=ШЕСТН.В.ДВ("6a";8) возвращает значение «01101010».
ШЕСТН.В.ДЕС
The result is the number for the hexadecimal number string entered.
ШЕСТН.В.ДЕС(Число)
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.
=ШЕСТН.В.ДЕС("6a") возвращает значение 106.