DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Excel “Engineering Functions” in Office 365!!

#engineeringfunctions #excelfunctions #excel

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)
Enter fullscreen mode Exit fullscreen mode

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

=BIN2HEX (number, [places])
Enter fullscreen mode Exit fullscreen mode

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

=BIN2OCT(number, [places])
Enter fullscreen mode Exit fullscreen mode

| 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)
Enter fullscreen mode Exit fullscreen mode

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

=BITLSHIFT(number, shift\_amount)
Enter fullscreen mode Exit fullscreen mode

| 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)
Enter fullscreen mode Exit fullscreen mode

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

=BITRSHIFT(number, shift\_amount)
Enter fullscreen mode Exit fullscreen mode

| 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)
Enter fullscreen mode Exit fullscreen mode

| 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])
Enter fullscreen mode Exit fullscreen mode

| 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)
Enter fullscreen mode Exit fullscreen mode

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

=DEC2BIN(number, [places])
Enter fullscreen mode Exit fullscreen mode

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

=DEC2HEX(number, [places])
Enter fullscreen mode Exit fullscreen mode

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

=DEC2OCT(number, [places])
Enter fullscreen mode Exit fullscreen mode

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

=DELTA(number 1, [number 2])
Enter fullscreen mode Exit fullscreen mode

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

=HEX2BIN(number, [places])
Enter fullscreen mode Exit fullscreen mode

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

=HEX2DEC(number)
Enter fullscreen mode Exit fullscreen mode

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

=HEX2OCT(number, [places])
Enter fullscreen mode Exit fullscreen mode

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

=IMABS(inumber)
Enter fullscreen mode Exit fullscreen mode

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

=IMAGINARY(inumber)
Enter fullscreen mode Exit fullscreen mode

| 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)
Enter fullscreen mode Exit fullscreen mode

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

=IMPRODUCT(inumber, [inumber2],…)
Enter fullscreen mode Exit fullscreen mode

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

=IMREAL(inumber)
Enter fullscreen mode Exit fullscreen mode

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

=IMSUB(inumber 1, inumber 2)
Enter fullscreen mode Exit fullscreen mode

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

=IMSUM(inumber 1, inumber 2)
Enter fullscreen mode Exit fullscreen mode

| 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!!

Top comments (0)

Read next

boscodomingo profile image

The ultimate Node Test Runner + TypeScript + ENV variables guide

Bosco Domingo -

vidvatek profile image

How to Add Days in Date in React Native Calendar

vidvatek -

thiagoolopess profile image

Backup Automatizado MySQL com ShellScript

Thiago Lopes -

vkazulkin profile image

AWS SnapStart - Part 19 Measuring cold starts and deployment time with Java 17 using different Lambda memory settings

Vadym Kazulkin -