Posljednja promjena 24.07.2005
| Engineering | ||||
| Name | Source | Type | Description | Syntax |
| BESSELI | Analysis ToolPak | Engineering | Returns the Bessel function evaluated for purely imaginary arguments | =BESSELI(x,n) |
| BESSELK | Analysis ToolPak | Engineering | Returns the modified Bessel function represented by Kn(x) | =BESSELK(x,n) |
| BESSELY | Analysis ToolPak | Engineering | Returns the Bessel / Weber / Neumann function Yn(x) | =BESSELY(x,n) |
| BESSELJ | Analysis ToolPak | Engineering | Returns the Bessel function represented by Jn(x) | =BESSELJ(x,n) |
| BIN2DEC | Analysis ToolPak | Engineering | Converts binary number to decimal | =BIN2DEC(Number) |
| BIN2HEX | Analysis ToolPak | Engineering | Converts binary number to hexadecimal | =BIN2HEX(Number,Places) |
| BIN2OCT | Analysis ToolPak | Engineering | Converts binary number to octal | =BIN2OCT(Number,Places) |
| COMPLEX | Analysis ToolPak | Engineering | Converts real and imaginary coefficients into complex numbers of the form x + yi or x + yj depending upon suffix | =COMPLEX(real_num,i_num,suffix) |
| CONVERT | Analysis ToolPak | Engineering | Converts a number from one measurement system to another | =CONVERT(number,from_unit,to_unit) |
| DEC2BIN | Analysis ToolPak | Engineering | Converts a decimal number to binary | =DEC2BIN(Number) |
| DEC2HEX | Analysis ToolPak | Engineering | Converts a decimal number to hexadecimal | =DEC2HEX(Number) |
| DEC2OCT | Analysis ToolPak | Engineering | Converts a decimal number to octal | =DEC2OCT(Number) |
| DELTA | Analysis ToolPak | Engineering | Test whether two values are equal | =DELTA(number1,number2) |
| ERF | Analysis ToolPak | Engineering | Returns the error function integrated between lower_limit and upper_limit | =ERF(lower_limit,upper_limit) |
| ERFC | Analysis ToolPak | Engineering | Returns the complementary ERF function integrated between x and infinity | =ERFC(x) |
| GESTEP | Analysis ToolPak | Engineering | Tests whether a number is greater than a threshold value | =GESTEP(number,step) |
| HEX2BIN | Analysis ToolPak | Engineering | Converts a hexadecimal to a binary | =HEX2BIN(Number,Places) |
| HEX2DEC | Analysis ToolPak | Engineering | Converts a hexadecimal to a decimal | =HEX2DEC(Number) |
| HEX2OCT | Analysis ToolPak | Engineering | Converts a hexadecimal to an octal | =HEX2OCT(Number,Places) |
| IMABS | Analysis ToolPak | Engineering | Returns the absolute value (modulus) of a complex number provided in the text format “x + yi” or “x + yj” | =IMABS(inumber) |
| IMAGINARY | Analysis ToolPak | Engineering | Returns the imaginary coefficient of a complex number provided in the text format “x + yi” or “x + yj” | =IMAGINARY(inumber) |
| IMARGUMENT | Analysis ToolPak | Engineering | Returns the argument theta – an angle expressed in radians | =IMARGUMENT(inumber) |
| IMCONJUGATE | Analysis ToolPak | Engineering | Returns the complex conjugate of a complex number provided in the text format “x + yi” or “x + yj” | =IMCONJUGATE(inumber) |
| IMCOS | Analysis ToolPak | Engineering | Returns the cosine of a complex number provided in the text format “x + yi” or | =IMCOS(inumber) |
| IMDIV | Analysis ToolPak | Engineering | Returns the quotient of two complex numbers provided in the text format “x + yi” or “x + yj” | =IMDIV(inumber1,inumber2) |
| IMEXP | Analysis ToolPak | Engineering | Returns the exponential of a complex number provided in the text format “x + yi” or “x + yj” | =IMEXP(inumber) |
| IMLN | Analysis ToolPak | Engineering | Returns the natural logarithm of a complex number provided in the text format “x + yi” or “x + yj” | =IMLN(inumber) |
| IMLOG10 | Analysis ToolPak | Engineering | Returns the base-10 logarithm of a complex number provided in the text format “x + yi” or “x + yj” | =IMLOG10(inumber) |
| IMLOG2 | Analysis ToolPak | Engineering | Returns the base-2 logarithm of a complex number provided in the text format “x + yi” or “x + yj” | =IMLOG2(inumber) |
| IMPOWER | Analysis ToolPak | Engineering | Returns a complex number provided in the text format “x + yi” or “x + yj” raised to an integer number | =IMPOWER(inumber,number) |
| IMPRODUCT | Analysis ToolPak | Engineering | Returns the product of 2 – 29 complex numbers provided in the text format “x + yi” or “x + yj” | =IMPRODUCT(inumber1,inumber2,…) |
| IMREAL | Analysis ToolPak | Engineering | Returns the real coefficient of a complex number provided in the text format “x + yi” or “x + yj” | =IMREAL(inumber) |
| IMSIN | Analysis ToolPak | Engineering | Returns the sine of a complex number provided in the text format “x + yi” or | =IMSIN(inumber) |
| IMSQRT | Analysis ToolPak | Engineering | Returns the square root of a complex number provided in the text format “x + yi” or “x + yj” | =IMSQRT(inumber) |
| IMSUB | Analysis ToolPak | Engineering | Returns the difference of two complex numbers provided in the text format “x + yi” or “x + yj” | =IMSUB(inumber1,inumber2) |
| IMSUM | Analysis ToolPak | Engineering | Returns the sum of 2 – 29 complex numbers provided in the text format “x + yi” or “x + yj” | =IMSUM(inumber1,inumber2,…) |
| OCT2BIN | Analysis ToolPak | Engineering | Converts an octal number to binary | =OCT2BIN(number,places) |
| OCT2DEC | Analysis ToolPak | Engineering | Converts an octal number to decimal | =OCT2DEC(number) |
| OCT2HEX | Analysis ToolPak | Engineering | Converts an octal number to hexadecimal | =OCT2HEX(number,places) |