# Excel “Engineering Functions” in Office 365!!

Andrews Originally published at geekexcel.com on ・5 min read

## Engineering Functions in Excel:

This page shows the list of built-in Excel Engineering Functions in Office 365.

Using the Excel Engineering functions, you can perform the most often used engineering calculations quickly.

Click on a function name or read more columns in order to know the complete description of the function with examples.

Note: Excel version is specified in some functions that indicate the introduction of that particular function in Excel. For example, 2013 indicates that the function will be available in Excel 2013 and all the newest versions.

| S. No | Function | Explanation & Syntax | Read More |
| 1 | BIN2DEC Function | Converts Binary numbers to Decimal values.

``````=BIN2DEC (number)
``````

| 2 | BIN2HEX Function | Converts Binary numbers to Hexadecimal numbers.

``````=BIN2HEX (number, [places])
``````

| 3 | BIN2OCT Function | Converts Binary numbers to Octal numbers.

``````=BIN2OCT(number, [places])
``````

| 4 | BITAND Function (2013) | Finds Bitwise AND of two numbers and returns the output as a decimal value.

``````=BITAND(number 1, number 2)
``````

| 5 | BITLSHIFT Function (2013) | Shifts the number (binary value) by the specified number of bits.

``````=BITLSHIFT(number, shift\_amount)
``````

| 6 | BITOR Function (2013) | Finds Bitwise OR of two numbers and returns the output as a decimal number.

``````=BITOR(number 1, number 2)
``````

| 7 | BITRSHIFT Function (2013) | Shifts bits by the specified number of times to the right.

``````=BITRSHIFT(number, shift\_amount)
``````

| 8 | BITXOR Function (2013) | Performs bitwise XOR of two decimal numbers and returns the output as a decimal value.

``````=BITXOR(number 1, number 2)
``````

| 9 | COMPLEX Function | Converts a real and imaginary coefficient into a complex number in the form of a+bi.

``````=COMPLEX(real\_num, i\_num, [suffix])
``````

| 10 | CONVERT Function | Converts a number from one unit type to another unit type.

``````=CONVERT(number, from\_unit, to\_unit)
``````

| 11 | DEC2BIN Function | Converts the decimal number into binary values.

``````=DEC2BIN(number, [places])
``````

| 12 | DEC2HEX Function | Converts the decimal numbers into hexadecimal numbers.

``````=DEC2HEX(number, [places])
``````

| 13 | DEC2OCT Function | Converts a decimal number to octal value.

``````=DEC2OCT(number, [places])
``````

| 14 | DELTA Function | Checks whether the two values are equal or not.

``````=DELTA(number 1, [number 2])
``````

| 15 | HEX2BIN Function | Converts the hexadecimal value into a decimal value.

``````=HEX2BIN(number, [places])
``````

| 16 | HEX2DEC Function | Converts the hexadecimal value into a decimal value.

``````=HEX2DEC(number)
``````

| 17 | HEX2OCT Function | Converts the hexadecimal number into an octal number.

``````=HEX2OCT(number, [places])
``````

| 18 | IMABS Function | Returns the absolute value of the complex number.

``````=IMABS(inumber)
``````

| 19 | IMAGINARY Function | Returns the Imaginary Co-efficient of a given complex number.

``````=IMAGINARY(inumber)
``````

| 20 | IMPOWER Function | Returns a complex number (X+Yi or X+Yj) raised to a given number.

``````=IMPOWER(inumber, number)
``````

| 21 | IMPRODUCT Function | Returns the product of one or more complex numbers (1 – 255 complex numbers).

``````=IMPRODUCT(inumber, [inumber2],…)
``````

| 22 | IMREAL Function | Returns the real coefficient of a complex number in the form of ( X+Yi ).

``````=IMREAL(inumber)
``````

| 23 | IMSUB Function | Returns the difference between two complex numbers.

``````=IMSUB(inumber 1, inumber 2)
``````

| 24 | IMSUM Function | Finds the sum of the two complex numbers.

``````=IMSUM(inumber 1, inumber 2)
``````

You have learned the complete list of Engineering Functions in Excel. This list assisted you to understand each function by knowing its explanation, basic syntax, and examples.

Drop your valuable queries/feedback in the below comment section. Thanks for visiting Geek Excel!! Keep Learning with us!!

Posted on by:

### Andrews

Founder of Geek Excel!! Blog for Excel Tutorials