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)