Excel Engineering Functions perform the most commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases
What is IMSECH function in Excel? IMSECH function is one of Engineering functions in Microsoft Excel that returns the hyperbolic secant of a complex number in x+yi or x+yj text format. Syntax of IMSECH function IMSECH(inumber) The IMSECH function syntax has the following arguments. Inumber: A complex number for which you want the hyperbolic secant. IMSECH formula …
What is HEX2OCT function in Excel? HEX2OCT function is one of Engineering functions in Microsoft Excel that converts a hexadecimal number to octal. Syntax of HEX2OCT function HEX2OCT(number, [places]) The HEX2OCT function syntax has the following arguments: Number: The hexadecimal number you want to convert. Number cannot contain more than 10 characters. The most significant bit of …
What is HEX2DEC function in Excel? HEX2DEC function is one of Engineering functions in Microsoft Excel that converts a hexadecimal number to decimal. Syntax of HEX2DEC function HEX2DEC(number) The HEX2DEC function syntax has the following arguments: Number: The hexadecimal number you want to convert. Number cannot contain more than 10 characters (40 bits). The most significant bit …
What is ERFC function in Excel? ERFC function is one of Engineering functions in Microsoft Excel that returns the complementary ERF function integrated between x and infinity. Syntax of ERFC function ERFC(x) The ERFC function syntax has the following arguments: X: The lower bound for integrating ERFC. ERFC formula explanation If x is nonnumeric, ERFC returns the …
What is ERF.PRECISE function in Excel? IMCOT function is one of Engineering functions in Microsoft Excel that returns the error function. Syntax of ERF.PRECISE function ERF.PRECISE(x) The ERF.PRECISE function syntax has the following argument: X: The lower bound for integrating ERF.PRECISE. ERF.PRECISE formula expalantion If lower_limit is nonnumeric, ERF.PRECISE returns the #VALUE! error value. Example of ERF.PRECISE function …
What is ERF function in Excel? ERF function is one of Engineering functions in Microsoft Excel that returns the error function integrated between lower_limit and upper_limit. Syntax of ERF function ERF(lower_limit,[upper_limit]) The ERF function syntax has the following arguments: Lower_limit: The lower bound for integrating ERF. Upper_limit(Optional): The upper bound for integrating ERF. If omitted, ERF integrates …
What is OCT2HEX function in Excel? OCT2HEX function is one of Engineering functions in Microsoft Excel that converts an octal number to hexadecimal. Syntax of OCT2HEX function OCT2HEX(number, [places]) The OCT2HEX function syntax has the following arguments: Number: The octal number you want to convert. Number may not contain more than 10 octal characters (30 bits). The …
What is OCT2DEC function in Excel? OCT2DEC function is one of Engineering functions in Microsoft Excel that converts an octal number to decimal. Syntax of OCT2DEC function OCT2DEC(number) The OCT2DEC function syntax has the following arguments: Number: The octal number you want to convert. Number may not contain more than 10 octal characters (30 bits). The most significant …
What is OCT2BIN function in Excel? OCT2BIN function is one of Engineering functions in Microsoft Excel that converts an octal number to binary. Syntax of OCT2BIN function OCT2BIN(number, [places]) The OCT2BIN function syntax has the following arguments: Number: The octal number you want to convert. Number may not contain more than 10 characters. The most significant bit …
What is IMTAN function in Excel? IMTAN function is one of Engineering functions in Microsoft Excel that returns the tangent of a complex number in x+yi or x+yj text format. Syntax of IMTAN function IMTAN(inumber) The IMTAN function syntax has the following arguments. Inumber: A complex number for which you want the tangent. IMTAN formula explanation …
What is IMSUM function in Excel? IMSUM function is one of Engineering functions in Microsoft Excel that returns the sum of two or more complex numbers in x + yi or x + yj text format. Syntax of IMSUM function IMSUM(inumber1, [inumber2], …) The IMSUM function syntax has the following arguments: Inumber1, [inumber2], … Inumber1 is required, …
What is IMSUB function in Excel?IMSUB function is one of Engineering functions in Microsoft Excel that returns the difference of two complex numbers in x + yi or x + yj text format. Syntax of IMSUB function IMSUB(inumber1, inumber2) The IMSUB function syntax has the following arguments: Inumber1: The complex number from which to subtract inumber2. Inumber2: The …
What is IMSINH function in Excel?IMSINH function is one of Engineering functions in Microsoft Excel that returns the hyperbolic sine of a complex number in x+yi or x+yj text format. Syntax of IMSINH function IMSINH(inumber) The IMSINH function syntax has the following arguments. Inumber: A complex number for which you want the hyperbolic sine. IMSINH formula explanation …
What is IMSIN function in Excel? IMSIN function is one of Engineering functions in Microsoft Excel that returns the sine of a complex number in x + yi or x + yj text format. Syntax of IMSIN function IMSIN(inumber) The IMSIN function syntax has the following arguments: Inumber: A complex number for which you want the sine. …
What is IMABS function in Excel? IMABS function is one of Engineering functions in Microsoft Excel that returns the absolute value (modulus) of a complex number in x + yi or x + yj text format. Syntax of IMABS function IMABS(inumber) The IMABS function syntax has the following arguments: Inumber: A complex number for which you …
What is IMSQRT function in Excel? IMSQRT function is one of Engineering functions in Microsoft Excel that returns the square root of a complex number in x + yi or x + yj text format. Syntax of IMSQRT function IMSQRT(inumber) The IMSQRT function syntax has the following arguments: Inumber: A complex number for which you want the …
What is IMREAL function in Excel? IMREAL function is one of Engineering functions in Microsoft Excel that returns the real coefficient of a complex number in x + yi or x + yj text format. Syntax of IMREAL function IMREAL(inumber) The IMREAL function syntax has the following arguments: Inumber: A complex number for which you want …
What is IMPRODUCT function in Excel? IMPRODUCT function is one of Engineering functions in Microsoft Excel that returns the product of 1 to 255 complex numbers in x + yi or x + yj text format. Syntax of IMPRODUCT function IMPRODUCT(inumber1, [inumber2], …) The IMPRODUCT function syntax has the following arguments: Inumber1, [inumber2], … Inumber1 is …
What is IMPOWER function in Excel? IMPOWER function is one of Engineering functions in Microsoft Excel that returns a complex number in x + yi or x + yj text format raised to a power. Syntax of IMPOWER function IMPOWER(inumber, number) The IMPOWER function syntax has the following arguments: Inumber: A complex number you want to raise to a …
What is IMLOG2 function in Excel? IMLOG2 function is one of Engineering functions in Microsoft Excel that returns the base-2 logarithm of a complex number in x + yi or x + yj text format. Syntax of IMLOG2 function IMLOG2(inumber) The IMLOG2 function syntax has the following arguments: Inumber: A complex number for which you want the …
What is IMLOG10 function in Excel? IMLOG10 function is one of Engineering functions in Microsoft Excel that returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. Syntax of IMLOG10 function IMLOG10(inumber) The IMLOG10 function syntax has the following arguments: Inumber: A complex number for which you …
What is IMLN function in Excel? IMLN function is one of Engineering functions in Microsoft Excel that returns the natural logarithm of a complex number in x + yi or x + yj text format. Syntax of IMLN function IMLN(inumber) The IMLN function syntax has the following arguments: Inumber: A complex number for which you want the …
What is IMEXP function in Excel? IMEXP function is one of Engineering functions in Microsoft Excel that returns the exponential of a complex number in x + yi or x + yj text format. Syntax of IMEXP function IMEXP(inumber) The IMEXP function syntax has the following arguments: Inumber: A complex number for which you want the exponential. …
What is IMDIV function in Excel? IMDIV function is one of Engineering functions in Microsoft Excel that returns the quotient of two complex numbers in x + yi or x + yj text format. Syntax of IMDIV function IMDIV(inumber1, inumber2) The IMDIV function syntax has the following arguments: Inumber1: The complex numerator or dividend. Inumber2: The complex denominator …
What is IMCSCH function in Excel? IMCSCH function is one of Engineering functions in Microsoft Excel that returns the hyperbolic cosecant of a complex number in x+yi or x+yj text format. Syntax of IMCSCH function IMCSCH(inumber) The IMCSCH function syntax has the following arguments. Inumber: A complex number for which you want the hyperbolic cosecant. IMCSCH formula …
What is IMCSC function in Excel? IMCSC function is one of Engineering functions in Microsoft Excel that returns the cosecant of a complex number in x+yi or x+yj text format. Syntax of IMCSC function IMCSC(inumber) Inumber: A complex number for which you want the cosecant. IMCSC formula explanation Use COMPLEX to convert real and imaginary coefficients into …
What is IMCOT function in Excel? IMCOT function is one of Engineering functions in Microsoft Excel that returns the cotangent of a complex number in x+yi or x+yj text format. Syntax of IMCOT function IMCOT(inumber) The IMCOT function syntax has the following arguments. Inumber: A complex number for which you want the cotangent. IMCOT formula explanation Use COMPLEX …
What is GESTEP function in Excel? GESTEP function is one of Engineering functions in Microsoft Excel that returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold. Syntax of GESTEP …
What is CONVERT function in Excel? CONVERT function is one of Engineering functions in Microsoft Excel that converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. Syntax of CONVERT function CONVERT(number,from_unit,to_unit) Number is the value in from_units to …
What is COMPLEX function in Excel? COMPLEX function is one of Engineering functions in Microsoft Excel that converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. Syntax of COMPLEX function COMPLEX(real_num, i_num, [suffix]) The COMPLEX function syntax has the following arguments: Real_num: The real coefficient of the …
What is DEC2BIN function in Excel? DEC2BIN function is one of Engineering functions in Microsoft Excel that converts a decimal number to binary. Syntax of DEC2BIN function DEC2BIN(number, [places]) The DEC2BIN function syntax has the following arguments: Number: The decimal integer you want to convert. If number is negative, valid place values are ignored and DEC2BIN …
What is BITLSHIFT function in Excel? BITLSHIFT function is one of Engineering functions in Microsoft Excel that returns a number shifted left by the specified number of bits. Syntax of BITLSHIFT function BITLSHIFT(number, shift_amount) The BITLSHIFT function syntax has the following arguments. Number Required. Number must be an integer greater than or equal to 0. Shift_amount …
What is BITAND function in Excel? BITAND function is one of Engineering functions in Microsoft Excel that returns a bitwise ‘AND’ of two numbers. Syntax of BITAND function BITAND( number1, number2) The BITAND function syntax has the following arguments. Number1: Must be in decimal form and greater than or equal to 0. Number2: Must be in …
What is BIN2OCT function in Excel? BIN2OCT function is one of Engineering functions in Microsoft Excel that converts a binary number to octal. Syntax of BIN2OCT function BIN2OCT(number, [places]) The BIN2OCT function syntax has the following arguments: Number: The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most …
What is BIN2HEX function in Excel? BIN2HEX function is one of Engineering functions in Microsoft Excel that converts a binary number to hexadecimal. Syntax of BIN2HEX function BIN2HEX(number, [places]) The BIN2HEX function syntax has the following arguments: Number: The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most …
What is BIN2DEC function in Excel? BIN2DEC function is one of Engineering functions in Microsoft Excel that converts a binary number to decimal. Syntax of BIN2DEC function BIN2DEC(number) The BIN2DEC function syntax has the following arguments: Number: The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant …
What is BESSELY function in Excel? BESSELY function is one of Engineering functions in Microsoft Excel that returns the Bessel function, which is also called the Weber function or the Neumann function. Syntax of BESSELY function BESSELY(X, N) The BESSELY function syntax has the following arguments: X: The value at which to evaluate the function. N: …
What is BESSELK function in Excel? BESSELK function is one of Engineering functions in Microsoft Excel that returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments. Syntax of BESSELK function BESSELK(X, N) The BESSELK function syntax has the following arguments: X: The value at which to evaluate the …
What is BESSELJ function in Excel? BESSELJ function is one of Engineering functions in Microsoft Excel that returns the Bessel function. Syntax of BESSELJ function BESSELJ(X, N) The BESSELJ function syntax has the following arguments: X: The value at which to evaluate the function. N: The order of the Bessel function. If n is not an …
What is BESSELI function in Excel? BESSELI function is one of Engineering functions in Microsoft Excel that returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments. Syntax of BESSELI function BESSELI(X, N) The BESSELI function syntax has the following arguments: X: The value at which to evaluate the …