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