loading...

Excel “Engineering Functions” in Office 365!!

excelgeek profile image 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)

| Read More about BIN2DEC Function |
| 2 | BIN2HEX Function | Converts Binary numbers to Hexadecimal numbers.

=BIN2HEX (number, [places])

| Read More about BIN2HEX Function |
| 3 | BIN2OCT Function | Converts Binary numbers to Octal numbers.

=BIN2OCT(number, [places])

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

=BITAND(number 1, number 2)

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

=BITLSHIFT(number, shift\_amount)

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

=BITOR(number 1, number 2)

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

=BITRSHIFT(number, shift\_amount)

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

=BITXOR(number 1, number 2)

| Read More about BITXOR Function |
| 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])

| Read More about COMPLEX Function |
| 10 | CONVERT Function | Converts a number from one unit type to another unit type.

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

| Read More about CONVERT Function |
| 11 | DEC2BIN Function | Converts the decimal number into binary values.

=DEC2BIN(number, [places])

| Read More about DEC2BIN Function |
| 12 | DEC2HEX Function | Converts the decimal numbers into hexadecimal numbers.

=DEC2HEX(number, [places])

| Read More about DEC2HEX Function |
| 13 | DEC2OCT Function | Converts a decimal number to octal value.

=DEC2OCT(number, [places])

| Read More about DEC2OCT Function |
| 14 | DELTA Function | Checks whether the two values are equal or not.

=DELTA(number 1, [number 2])

| Read More about DELTA Function |
| 15 | HEX2BIN Function | Converts the hexadecimal value into a decimal value.

=HEX2BIN(number, [places])

| Read More about HEX2BIN Function |
| 16 | HEX2DEC Function | Converts the hexadecimal value into a decimal value.

=HEX2DEC(number)

| Read More about HEX2DEC Function |
| 17 | HEX2OCT Function | Converts the hexadecimal number into an octal number.

=HEX2OCT(number, [places])

| Read More about HEX2OCT Function |
| 18 | IMABS Function | Returns the absolute value of the complex number.

=IMABS(inumber)

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

=IMAGINARY(inumber)

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

=IMPOWER(inumber, number)

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

=IMPRODUCT(inumber, [inumber2],…)

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

=IMREAL(inumber)

| Read More about IMREAL Function |
| 23 | IMSUB Function | Returns the difference between two complex numbers.

=IMSUB(inumber 1, inumber 2)

| Read More about IMSUB Function |
| 24 | IMSUM Function | Finds the sum of the two complex numbers.

=IMSUM(inumber 1, inumber 2)

| Read More about IMSUM Function |

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:

excelgeek profile

Andrews

@excelgeek

Founder of Geek Excel!! Blog for Excel Tutorials

Discussion

pic
Editor guide