From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/01/04060115.xhp | 428 +++++++++++++++++++++++++ 1 file changed, 428 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/04060115.xhp (limited to 'helpcontent2/source/text/scalc/01/04060115.xhp') diff --git a/helpcontent2/source/text/scalc/01/04060115.xhp b/helpcontent2/source/text/scalc/01/04060115.xhp new file mode 100644 index 000000000..f62e4d2a2 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/04060115.xhp @@ -0,0 +1,428 @@ + + + + + + + Add-in Functions, List of Analysis Functions Part One + /text/scalc/01/04060115.xhp + + + + + + + add-ins; analysis functions + analysis functions + + +

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. +
+ +
+ + +
+ + Bessel functions + BESSELI function + + + + +

BESSELI

+Calculates the modified Bessel function of the first kind In(x). + + +BESSELI(X; N) + X is the value on which the function will be calculated. + 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 +
+ +
+ + BESSELJ function + + + +

BESSELJ

+Calculates the Bessel function of the first kind Jn(x) (cylinder function). + + +BESSELJ(X; N) + X is the value on which the function will be calculated. + 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 +
+ +
+ + BESSELK function + + + +

BESSELK

+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) +
+ +
+ + BESSELY function + + + +

BESSELY

+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) +
+ +
+ + BIN2DEC function + converting;binary numbers, into decimal numbers + +mw added one entry + + +

BIN2DEC

+The result is the number for the binary (base-2) number string entered. + + +BIN2DEC(Number) + 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. +
+ +
+ + BIN2HEX function + converting;binary numbers, into hexadecimal numbers + +mw added one entry + + +

BIN2HEX

+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". +
+ +
+ + BIN2OCT function + converting;binary numbers, into octal numbers + +mw added one entry + + +

BIN2OCT

+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. +Places means the number of places to be output. + + +=BIN2OCT("1100100";4) returns "0144". +
+ +
+ + DELTA function + recognizing;equal numbers + +mw added one entry + + +

DELTA

+The result is TRUE (1) if both numbers, which are delivered as an argument, are equal, otherwise it is FALSE (0). + + +DELTA(Number1 [; Number2]) + + + =DELTA(1;2) returns 0. +
+ +
+ + DEC2BIN function + converting;decimal numbers, into binary numbers + +mw added one entry + + +

DEC2BIN

+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. +Places means the number of places to be output. + + +=DEC2BIN(100;8) returns "01100100". +
+ +
+ + DEC2HEX function + converting;decimal numbers, into hexadecimal numbers + +mw added one entr + + +

DEC2HEX

+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. +Places means the number of places to be output. + + +=DEC2HEX(100;4) returns "0064". +
+ +
+ + DEC2OCT function + converting;decimal numbers, into octal numbers + +mw added one entr + + +

DEC2OCT

+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. +Places means the number of places to be output. + + +=DEC2OCT(100;4) returns "0144". +
+ +
+ + ERF function + Gaussian error integral + +mw added one entr + + +

ERF

+Returns values of the Gaussian error integral. + + +ERF(LowerLimit [; UpperLimit]) + LowerLimit is the lower limit of the integral. + 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) returns 0.842701. +
+ +
+ + ERF.PRECISE function + Gaussian error integral + + + + +

ERF.PRECISE

+Returns values of the Gaussian error integral between 0 and the given limit. + +ERF.PRECISE(LowerLimit) +LowerLimit is the limit of the integral. The calculation takes place between 0 and this limit. + + + =ERF.PRECISE(1) returns 0.842701. + + + +COM.MICROSOFT.ERF.PRECISE +
+ +
+ + ERFC function + + + + +

ERFC

+Returns complementary values of the Gaussian error integral between x and infinity. + + +ERFC(LowerLimit) + LowerLimit is the lower limit of the integral + + + =ERFC(1) returns 0.157299. +
+ +
+ + ERFC.PRECISE function + + + + +

ERFC.PRECISE

+Returns complementary values of the Gaussian error integral between x and infinity. + +ERFC.PRECISE(LowerLimit) + LowerLimit is the lower limit of the integral + + + =ERFC.PRECISE(1) returns 0.157299. + + + +COM.MICROSOFT.ERFC.PRECISE +
+ +
+ + GESTEP function + numbers;greater than or equal to + +mw added one entry + + +

GESTEP

+The result is 1 if Number is greater than or equal to Step. + + +GESTEP(Number [; Step]) + + + =GESTEP(5;1) returns 1. +
+ +
+ + HEX2BIN function + converting;hexadecimal numbers, into binary numbers + +mw added one entry + + +

HEX2BIN

+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. +Places is the number of places to be output. + + +=HEX2BIN("6a";8) returns "01101010". +
+ +
+ + HEX2DEC function + converting;hexadecimal numbers, into decimal numbers + +mw added one entry + + +

HEX2DEC

+The result is the number for the hexadecimal number string entered. + + +HEX2DEC(Number) +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. +
+ +
+ + HEX2OCT function + converting;hexadecimal numbers, into octal numbers + +mw added one entry + + +

HEX2OCT

+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. +Places is the number of places to be output. + + +=HEX2OCT("6a";4) returns "0152". +
+ + +
+ + + + +
+ + + -- cgit v1.2.3