**Engineering Functions**

**CONVERT Function**

**=CONVERT (number, from_unit, to_unit)**

- number – the number you want to convert,
- from_unit – the current unit
- to_unit – the unit you want the value to convert in.

**Example:**

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

**Explanation:** This will convert the value 2000 from meter to yards.

**IMSUM Function**

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”)**

**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 the real coefficient.

**Explaination:** The real 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:**

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

**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:**

**Explanation:** Error function integrated between 0 and 0.745000 is 0.707929

**Template**

Further reading: Basic concepts Getting started with Excel Cell References