Engineering Functions in Excel
Engineering Functions in Excel
Excel boasts a vast library of functions, but don’t be overwhelmed! We’ll explore the most essential functions grouped into intuitive categories. Here is the list of Excel Formulas and Functions. We have included Excel functions, Description, Syntax. Explained with Example Formulas.
Engineering Functions
Delve into Specialized Engineering Calculations with Excel’s Engineering Functions. From converting between degrees and radians (DEGREES, RADIANS) to complex unit conversions (CONVERT), these functions cater to specific engineering disciplines and provide solutions for advanced technical calculations.
- Cater to specific engineering disciplines.
- Perform complex unit conversions and engineering calculations.
Function | Description | Syntax and Formula |
BESSELI | BESSELI is an Excel function that returns the modified Bessel function In(x). It is used to calculate the modified Bessel function of the first kind. | Syntax: BESSELI(x,n)x – The value for which to calculate the modified Bessel function.n – The order of the modified Bessel function. Formula: BESSELI(1,2)This formula will return the modified Bessel function of the first kind for x = 1 and order = 2. The result will be 0.440050585744933. |
BESSELJ | The BESSELJ function is an Excel function that returns the Bessel function of the first kind, Jn, of an order n and argument x. | Syntax: BESSELJ(x,n) Formula: BESSELJ(1,2) returns 0.440050585744933 |
BESSELK | The BESSELK function is an Excel function that returns the modified Bessel function K of the specified order and argument. | Syntax: BESSELK(x,n) Formula: BESSELK(2,3) returns 0.06899 |
BESSELY | The BESSELY function is an Excel function that calculates the Bessel function of the first kind, which is a mathematical function used to solve a variety of problems in physics, engineering, and mathematics. | Syntax: BESSELY(x,n) Formula: BESSELY(2,3)This formula will return the Bessel function of the first kind for x = 2 and n = 3. |
BIN2DEC | BIN2DEC is an Excel function that converts a binary number to a decimal number. | Syntax: BIN2DEC(number) Formula: BIN2DEC(10101) returns 21 |
BIN2HEX | The BIN2HEX function is used to convert a binary number to a hexadecimal number. | Syntax: BIN2HEX(number, [places]) Formula: BIN2HEX(10101010, 8)Result: AA |
BIN2OCT | BIN2OCT is an Excel function that converts a binary number to an octal number. | Syntax: BIN2OCT(number) Formula: BIN2OCT(10101010) returns 252 |
BITAND | BITAND is a logical function in Excel that performs a bitwise AND operation on two numbers. The syntax for the BITAND function is: BITAND(number1, number2). | Syntax: BITAND( number1, number2) Formula: BITAND(7, 11)This will return the result of 7 (111 in binary) AND 11 (1011 in binary), which is 3 (11 in binary). |
BITLSHIFT | BITLSHIFT is an Excel function that shifts the bits of a number to the left or right. It takes two arguments: the number to be shifted, and the number of bits to shift it. | Syntax: BITLSHIFT(number, shift_amount) Formula: BITLSHIFT(10, 2)This example shifts the bits of the number 10 to the left by two bits. The result is 40. |
BITOR | BITOR is an Excel logical function that returns a bitwise OR of two numbers. The syntax for the BITOR function is: BITOR(number1, number2). | Syntax: BITOR(number1, number2) Formula: BITOR(4, 5)This will return 5 as the result. |
BITRSHIFT | BITRSHIFT is an Excel function that shifts the bits of a number to the right. It takes two arguments: the number to be shifted and the number of positions to shift. | Syntax: BITRSHIFT(number, shift_amount) Formula: BITRSHIFT(10,2)This example shifts the bits of the number 10 two positions to the right, resulting in the value 2. |
BITXOR | The BITXOR function returns a bitwise ‘exclusive or’ of two numbers. | Syntax: BITXOR(number1, number2) Formula: BITXOR(5,7)This will return 4, as 5 XOR 7 = 4. |
COMPLEX | The COMPLEX function is used to convert real and imaginary coefficients into a complex number. | Syntax: COMPLEX(real_num, i_num, [suffix]) Formula: COMPLEX(5,3,”i”)This will return the complex number 5+3i. |
CONVERT | The CONVERT function is used to convert a number from one unit of measurement to another. | Syntax: CONVERT(number, from_unit, to_unit) Formula: CONVERT(10, “mi”, “km”)This example would convert 10 miles to kilometers, and the result would be 16.09344 kilometers. |
DEC2BIN | DEC2BIN is an Excel function that converts a decimal (base 10) number to a binary (base 2) number. | Syntax: DEC2BIN(number, [places]) Formula: DEC2BIN(10, 8) returns 00001010. |
DEC2HEX | DEC2HEX is an Excel function that converts a decimal number to a hexadecimal number. | Syntax: DEC2HEX(number, [places]) Formula: DEC2HEX(255,2)Result: FF |
DEC2OCT | The DEC2OCT function is a mathematical function in Microsoft Excel that converts a decimal number to an octal number. | Syntax: DEC2OCT(number, places) Formula: DEC2OCT(20,2)Result: 24 |
DELTA | The DELTA function in Excel returns 1 if two values are equal and 0 if they are not equal. | Syntax: DELTA(number1, number2) Formula: DELTA(A1, B1) |
ERF | The ERF function returns the error function integrated between two supplied limits. The error function is a special function used in probability and statistics to measure the area under a normal distribution curve. | Syntax: ERF(lower_limit, upper_limit) Formula: ERF(-1,2)This example returns the value of 0.954499736103642, which is the area under a normal distribution curve between -1 and 2. |
ERF.PRECISE | The ERF.PRECISE function is an Excel function that calculates the error function of a given value. The error function is a mathematical function used to calculate the probability that a normally distributed random variable will be within a certain range. | Syntax: ERF.PRECISE(x) Formula: ERF.PRECISE(0.5)This formula will return the error function of 0.5, which is 0.5204999. |
ERFC | ERFC is an Excel function that returns the complementary error function of a given number. | Syntax: ERFC(number) Formula: ERFC(0.5)This example returns the value 0.479500122. |
ERFC.PRECISE | The ERFC.PRECISE function is an Excel statistical function that returns the complementary error function integrated between lower_limit and upper_limit. The complementary error function is a special function used in statistics and probability theory. | Syntax: ERFC.PRECISE(lower_limit, upper_limit) Formula: To calculate the complementary error function integrated between 0 and 1, the formula would be: =ERFC.PRECISE(0,1) which returns 0.842700792949715. |
GESTEP | The GESTEP function returns a logical value of TRUE or FALSE depending on whether a number is greater than or equal to a given step value. | Syntax: GESTEP(number, step) Formula: GESTEP(7, 3)This will return TRUE as 7 is greater than or equal to 3. |
HEX2BIN | The HEX2BIN function in Excel is used to convert a hexadecimal number to a binary number. | Syntax: HEX2BIN(number, [places]) Formula: HEX2BIN(A1, 8)In this example, the HEX2BIN function will convert the hexadecimal number in cell A1 to a binary number with 8 places. |
HEX2DEC | HEX2DEC is an Excel function that converts a hexadecimal number to its decimal equivalent. | Syntax: HEX2DEC(number) Formula: HEX2DEC(“FF”) returns 255 |
HEX2OCT | The HEX2OCT function in Excel is used to convert a hexadecimal number to an octal number. | Syntax: HEX2OCT(number) Formula: HEX2OCT(A1) where A1 contains the hexadecimal number “F1” will return the octal number “361”. |
IMABS | The IMABS function is an Excel function that returns the absolute value of a complex number. | Syntax: IMABS(inumber) Formula: IMABS(5+3i)Result: 5 |
IMAGINARY | The IMAGINARY function returns the imaginary coefficient of a complex number in Excel. | Syntax: IMAGINARY(inumber) Formula: IMAGINARY(2+3i)This formula will return 3, which is the imaginary coefficient of the complex number 2+3i. |
IMARGUMENT | The IMARGUMENT function returns the argument theta, which is the angle associated with the complex number in x + iy (x and y are real numbers). | Syntax: IMARGUMENT(inumber) Formula: IMARGUMENT(2+3i) returns 0.982793723247329 |
IMCONJUGATE | The IMCONJUGATE function returns the complex conjugate of a complex number. | Syntax: IMCONJUGATE(inumber) Formula: IMCONJUGATE(2+4i)Result: 2-4i |
IMCOS | The IMCOS function returns the cosine of an angle given in radians. | Syntax: IMCOS(number) Formula: To calculate the cosine of 2 radians, use the following Formula:=IMCOS(2)The result would be -0.41614683654714. |
IMCOSH | The IMCOSH function returns the hyperbolic cosine of a complex number in x + yi or x + yj text format. | Syntax: IMCOSH(inumber) Formula: IMCOSH(1+2i)Result: 3.76219 + 0.96623i |
IMCOT | IMCOT is an Excel function that returns the imaginary part of a complex number. | Syntax: IMCOT(inumber) Formula: IMCOT(2+3i)Result: -3 |
IMCSC | The IMCSC function is used to calculate the complex conjugate of a complex number in Microsoft Excel. | Syntax: IMCSC(inumber) Formula: IMCSC(2+3i)Result: 2-3i |
IMCSCH | EDULEThe IMCSCHEDULE function in Microsoft Excel is used to calculate the number of payments for a loan or an annuity. | Syntax: IMCSCHEDULE(principal, interest, payments, start_period, end_period, type) Formula: To calculate the number of payments for a loan of $1000 with an interest rate of 5% and a payment period of 12 months, the following formula can be used:IMCSCHEDULE(1000, 0.05, 12, 1, 12, 0)The result of this formula will be 12, meaning that the loan will have 12 payments. |
IMDIV | The IMDIV function returns the result of a complex number division in the imaginary number format. | Syntax: IMDIV(inumber1, inumber2) Formula: To divide the imaginary numbers 5i and 2i, the formula would be:=IMDIV(5i,2i)The result would be 2.5i. |
IMEXP | The IMEXP function is an Excel function that imports data from a text file into a worksheet. It is a useful tool for importing data from other sources into Excel. | Syntax: IMEXP(filename, [worksheet], [start_row], [start_column], [import_type], [import_options]) Formula: IMEXP(“C:\mydata.txt”, “Sheet1”, 1, 1, “Delimited”, “FieldsPerRecord=4”) |
IMLN | IMLN: The IMLN function returns the inverse matrix logarithm of a matrix. | Syntax: IMLN(matrix) Formula: IMLN(A1:B2)Where A1:B2 is a 2×2 matrix containing the values 1, 2, 3 and 4. The result of this formula would be the inverse matrix logarithm of the matrix. |
IMLOG10 | The IMLOG10 function returns the logarithm of a number to the base 10. | Syntax: IMLOG10(number) Formula: IMLOG10(100)The result of this formula is 2, as the logarithm of 100 to the base 10 is 2. |
IMLOG2 | IMLOG2 is an Excel function used to calculate the binary logarithm of a number. The function takes a single argument, which is the number for which the binary logarithm is to be calculated. | Syntax: IMLOG2(number) Formula: IMLOG2(8)This formula will return 3, as the binary logarithm of 8 is 3. |
IMPOWER | The IMPOWER function is an Excel function that returns the given number raised to the power of another number. | Syntax: IMPOWER(number, power) Formula: IMPOWER(2,3)This will return 8, as 2 to the power of 3 is 8. |
IMPRODUCT | The IMPRODUCT function returns the product of two or more complex numbers. | Syntax: IMPRODUCT(inumber1,inumber2,…) Formula: IMPRODUCT(2+3i,4+5i)This would return 22+22i. |
IMREAL | IMREAL is an Excel function that returns TRUE if a number is a real number and FALSE if it is not. | Syntax: IMREAL(number) Formula: IMREAL(3.14)This example would return TRUE as 3.14 is a real number. |
IMSEC | The IMSEC function returns the number of seconds in a given time. | Syntax: IMSEC(time) Formula: IMSEC(“12:30:15”) returns 45015. |
IMSECH | The IMSECH function returns the inverse hyperbolic secant of a given number. | Syntax: IMSECH(number) Formula: IMSECH(0.5)The result of this function is 1.3169578969248. |
IMSIN | VThe IMSINV function returns the inverse of the matrix which is provided as an argument. | Syntax: IMSINV(array) Formula: IMSINV({1,2,3;4,5,6;7,8,9}) returns the inverse of the matrix {1,2,3;4,5,6;7,8,9} as {-0.222, 0.111, 0.333; 0.167, -0.056, -0.139; 0.056, 0.167, -0.056}. |
IMSINH | The IMSINH function returns the hyperbolic sine of a given number. | Syntax: IMSINH(number) Formula: IMSINH(2) returns 1.919154444 |
IMSQRT | IMSQRT is an Excel function that returns the imaginary component of the square root of a complex number. | Syntax: IMSQRT(inumber)inumber – A complex number for which you want to find the imaginary component of the square root. Formula: IMSQRT(2+3i)This will return 1.5i, which is the imaginary component of the square root of 2+3i. |
IMSUB | The IMSUB function returns the difference between two arrays of any size. | Syntax: IMSUB(array1, array2) Formula: IMSUB(A1:A5, B1:B5)This formula will return the difference between the two arrays A1:A5 and B1:B5. |
IMSUM | The IMSUM function calculates the sum of an array of numbers based on a given set of conditions. | Syntax: IMSUM(array, criteria) Formula: IMSUM(A1:A10, “>50”)This formula will sum all the numbers in the range A1:A10 that are greater than 50. |
IMTAN | The IMTAN function returns the modified Bessel function of the first kind, which is a mathematical function used to solve differential equations. | Syntax: IMTAN(x) Formula: IMTAN(2)This example returns the value 0.2078795763507619. |
OCT2BIN | OCT2BIN is an Excel function that converts an octal number to a binary number. | Syntax: OCT2BIN(number, [places])number: The octal number that you want to convert to a binary number.places: (optional) The number of characters to use. Formula: OCT2BIN(11)Result: 1011 |
OCT2DEC | The OCT2DEC function converts an octal number to a decimal number in Microsoft Excel. | Syntax: OCT2DEC(number) Formula: OCT2DEC(77)This example would return the decimal number 63. |
OCT2HEX | The OCT2HEX function converts an octal number to a hexadecimal number. | Syntax:OCT2HEX(number, [places]) Formula:OCT2HEX(11, 4)Result: 13 |
You May Like to Browers More


