Engineering Functions in Excel

The built-in Excel Engineering Functions have been provided to perform some of the most commonly used engineering calculations. In this article, we are going to learn how to use the Excel engineering function.

In this article, we are going to learn about the CONVERT function.

 

CONVERT Function

The CONVERT function is used to convert a value from one type to another. For instance, meter to yard.

The CONVERT function is:

=CONVERT (number, from_unit, to_unit)

  • number - the number you want to convert,
  • from_unit - the current unit
  • to_unit - the unit into which the value should be converted.

Example:

=Convert (2000,”m”,”yd”)

Explanation: This will convert the value of 2000 from meters to yards.

CONVERT Excel function

 

IMSUM Function

It returns the sum of a complex numbers.

The syntax of the IMSUM function is:

=IMSUM (inumber1, inumber2…)

  • inumber1 and inumber2 - complex numbers from 1 to 29 to add.

Example:

=IMSUM("3+4i", "5-3i")

IMSUM Excel function

 

IMREAL Function

Returns the real coefficient of a complex number in x + yi or x + yj text format.

The syntax of the IMREAL Function is:

=IMREAL (inumber)

  • Inumber - a complex number for which you want to know the real coefficient.

IMREAL Excel function

Explaination: The true coefficient of 6-9i is 6.

 

DELTA Function

Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise

The syntax of the DELTA Function is:

=DELTA (number1, number2)

  • Number1 is the first number and Number2 is the second number. If omitted, number2 is assumed to be zero.

Examples:

DELTA Excel function

Explanation: Number 5 is not equal to number 4, so the result is 0.

DELTA example

Explanation: Number 5 is equal to number 5, so the result is 1.

 

ERF Function

Returns the error function integrated between lower_limit and upper_limit.

The syntax of the ERF function is:

=ERF(lower_limit, upper_limit)

  • Lower_limit is the lower bound for integrating ERF
  • Upper_limit is the upper bound for integrating ERF. If omitted, ERF integrates between zero and lower_limit.

Example:

ERF Excel function

Explanation: The Erf function integrated between 0 and 0.745000 is 0.707929