Engineering functions

Excel Function CONVERT

The CONVERT() function is used to convert a number from one metric system to another.

The various metric system supported by the function are as follows:

Gram, Slug, Pound, Ounce, Grain,Stone,Ton

Meter, Nautical Mile, Inch, Foot, Yard, Angstrom, Lightyear

Year,Day,Month,Hour,Minute,Second

and various other metrics.

Number CONVERT Remarks Formula
23 5.07063203025218E-02 Gram to Pound =CONVERT(L5,"g","lbm")
11 12.0297462817148 Meter to Yard =CONVERT(L6,"m","yd")
56 0.00175 Ounce to Ton =CONVERT(L7,"ozm","ton")
97 5820 Hour to Minute =CONVERT(L8,"hr","mn")
5 -268.15 Kelvin to Celcius =CONVERT(L9,"K","C")
14 8.69919669132268E-03 meter/hr to miles/hr =CONVERT(L10,"m/hr","mph")
37 0.049617817315016 Watts to Horsepower =CONVERT(L11,"W","HP")

 

 

Excel Function DELTA

The DELTA() function is used to compare two numbers for equality.

This function takes two arguments only.

The function returns 1 if both the numbers are equal and o otherwise.

Number1 Number2 DELTA Formula
23 23 1 =DELTA(L20,M20)
11 -11 0 =DELTA(L21,M21)
56 22 0 =DELTA(L22,M22)
97 97 1 =DELTA(L23,M23)
5 4 0 =DELTA(L24,M24)
14 14 1 =DELTA(L25,M25)
37 45 0 =DELTA(L26,M26)

 

 

Excel Function ERF

The ERF() returns the error function that is integrated between a lower limit and the upper limit.

This function takes two arguments; lower limit and upper limit, both are positive numbers.

Prior to Excel 2010, a negative number on either parameter will result in an error, which has now been fixed.

Lower limit Upper limit ERF Formula
2 3 4.65564448404865E-03 =ERF(L34,M34)
4 7 1.54172579147627E-08 =ERF(L35,M35)
6 12 0 =ERF(L36,M36)
4 6 1.54172579147627E-08 =ERF(L37,M37)
8 6 0 =ERF(L38,M38)
1 -1 -1.68540158589943 =ERF(L39,M39)
21 21 0 =ERF(L40,M40)

 

 

Excel Function ERFC

The ERFC() function returns the complementary of the error function between a lower and infinity.

This function is similar to the ERF except that, this function complements the end value.

The formula for calculating ERFC is as follows:

excel engineering functions comparison and error functions convert delta erf erfc gestep

Lower limit ERFC Formula
2 4.67773498104726E-03 =ERFC(L48)
4 1.541725790028E-08 =ERFC(L49)
6 2.15197367124989E-17 =ERFC(L50)
4 1.541725790028E-08 =ERFC(L51)
8 1.12242971729829E-29 =ERFC(L52)
1 0.157299207050285 =ERFC(L53)
21 8.03245387102246E-194 =ERFC(L54)

 

 

Excel Function GESTEP

The GESTEP() function checks if the specified number is greater than the step size specified.

This function returns 1 if greater and 0 otherwise.

This function takes two arguments; number and step size.

The step size argument is optional and will taken as 0 if omitted.

Number Step size GESTEP Formula
2 3 0 =GESTEP(L65,M65)
4 7 0 =GESTEP(L66,M66)
6 12 0 =GESTEP(L67,M67)
4 6 0 =GESTEP(L68,M68)
8 1 =GESTEP(L69,M69)
1 -1 1 =GESTEP(L70,M70)
21 21 1 =GESTEP(L71,M71)

 

You can find similar Excel Questions and Answer hereunder

1) Vba delete entire row if contains certain text in Excel

2) engineering functions arithmetic operations of complex numbers imdiv improduct imsum imsub imsqrt

3) engineering functions trignometric functions of complex numbers imsin imcos imtan imcsc imsec imcot

4) Find and count instances of a character in a string in Excel

5) engineering functions log functions with complex numbers imln imlog10 imlog2 impower imexp

6) engineering functions arithmetic operations of complex numbers complex imabs imaginary imargument imconjugate imreal

7) engineering functions bessel functions besseli besselj besselk bessely

8) How to change the color of gridlines in a worksheet in Excel

9) How can I calculate values applying complex Engineering formulas using Excel?

10) engineering functions number conversions octal and hexadecimal oct2bin oct2dec oct2hex hex2bin hex2dec hex2oct

 

Here the previous and next chapter